There are some DMV functions that will return cached exection plans, including number of executions, min, max, avg runtime, resource consumption, etc. but the problem is that not all queries...

I believe there is an important role for "New Men" in IT, so long as you're referring to the smart and adaptable type who graduated from university with an MBA,...

The only users who automatically have access to all databases are members of the SYSADMIN role. For non-sysadmin users, you must create their account in a database. To faciliate the...

SQL Server running on Linux is interesting and a step forward, but SQL Server running on bare metal would be an even bolder move.

Eirikur Eiriksson (3/18/2016)

---

Easy enough, if differential backups are consistently 0 in content and no connections are made...

Once you've identified what you believe to be a list of databases no longer used, then set the database option 'Restrict Access' for each to RESTRICTED_USER mode (default is MULTI_USER),...

Even four years later it still sounds like a gee-wiz startup environment concept targeting a Millenial stereotype. It's unclear how BYOD benefits the employer, especially when the employer still pays...

Taking this one step further, how about SQL Server OS running on bare metal? If the machine is a dedicated database server, then you don't really need Windows or Linux....

I don't think electric shock can be used effectively to teach developers how to write set-based SQL... but it could be applied to discourage the use of cursors. 😉

If you only know "how" to do somthing technical, then at best you're just a cog in an organizational machine. Consider all these folks who use "brain dumps" to pass...

If you do create a linked server connection specifically for this purpose, then remember to drop it afterward or restrict it to only your login. Otherwise it could be abused...

My knowledge of SAN technology is limited, but I do know that when a SAN is setup, the disk array can be optimized to support different application case usages. For...

xsevensinzx (3/15/2016)

---

I really hope this works. I absolutely love Linux. I only use Windows because of SQL Server.

I also don't think this is to target the MySQL market share....

To copy rows from source table(s) to target tables(s) with minimal performance impact on both the source database (less blocking) and target database (less transaction logging), I would reccomend using...

The new Live Query Statistics feature (available when using SSMS 2016 with MSSQL 2014/2016) looks like it will be a game changer. How many times have you been watching a...