Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in your head. Dennes describes how he uses T-SQL queries for solving problems, whether it involves fixing the problems of missing indexes, preventing unrestrained autogrowth, avoiding index fragmentation, checking whether jobs have failed or avoiding memory stress conditions.
2016-07-08
10,110 reads
Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.
2016-07-07
3,150 reads
2016-07-06
132 reads
One of the challenges associated with running your workloads in Azure SQL Database is the limited level of management oversight. Fortunately, there is an alternative approach that leverages the functionality incorporated into the recently introduced Azure SQL Database Advisor - Marcin Policht provides a brief overview.
2016-07-06
3,869 reads
In this demo, we will give an introduction from 0 about Power BI and how to connect to Azure SQL Databases and Google Analytics
2016-07-05
1,367 reads
DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server that can be harnessed to this end: PowerShell is only part of the solution: there is also Central Management Server, Master /Target Agent and the Remote Server Administration Tools. It's time to work out your objectives and pick the most suitable technologies to meet them.
2016-07-05
3,753 reads
Uniqueness of values in specific columns can be enforced in a SQL Server table by creating a unique constraint or a unique index on those columns. In this article, Sergey Gigoyan looks at what the differences between the two are, and how SQL Server handles them both.
2016-07-04
4,824 reads
Learn how to use SSIS to load Delimited Flat Files to staging tables.
2016-07-01 (first published: 2015-04-20)
12,796 reads
A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see.
2016-07-01
1,213 reads
David Fitzjarrell takes a look at why the mutating table error is thrown, why it's not going to create data problems, and how to possibly fix it.
2016-07-01
3,541 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers