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...

Gary Varga (3/14/2016)

---

Eric M Russell (3/14/2016)

---

I use the term "BlackOps deployment" referring to those scenarios where IT performs an undocumented operation in production without going through he offical change control...

For years, folks have been using Linux servers as a VM host for running instances of Windows / SQL Server. At least for these customers, Windows is an uncessary OS...

.. You wish to temporarily disable all foreign key constraints on the table since this is an archive database and you orphaned records are acceptable for this one load only...