Useful tips for everyday
What is the difference between Windows Server 2008 R2 to Windows 7? Server 2008 is built on the same code base as Vista; you need…
What is data pump import? Data Pump Import (hereinafter referred to as Import for ease of reading) is a utility for loading an export dump…
How do I give access to SSRS reports? Click Home, and then click Folder settings. From there, create a new role assignment so that you…
How do I open SQLCMD? Start the sqlcmd utility and connect to a default instance of SQL Server On the Start menu click Run. In…
Can Azure SQL store images? Azure provides you the flexibility to store large amounts of data in either Azure Blob storage or Azure SQL database.…
What is group aggregation? Groups input documents by the specified _id expression and for each distinct grouping, outputs a document. The _id field of each…
How can I tell if a SQL Server Service Broker is enabled? Resolution Check to see whether Service Broker is enabled: select name,is_broker_enabled from sys.databases…
How can we solve the insurance problem? 10 tips for resolving issues with insurance companies Anticipate problems and create a place to keep records. Clarify…
How do I link two SQL Server instances with Kerberos? First, open SQL Server Management Studio and connect to the instance of your choice. Then,…
How can I tell how much memory my SQL Server is using? You can monitor memory use at the database level as follows. Launch SQL…