(Nakul Vachhrajani) A few days ago, we were changing the passwords of SQL Logins on our development SQL Server instances.
Tag: sql server
Pulling data from the error log
(Kenneth Fisher) The other day I was asked to pull a list of errors from the SQL Server log into a table for analysis. It seemed like something that others might find useful so I decided to post what I came up with.
What to do when your SQL CPU is at 100%
(Derek Dieter) We’ve all had it happen, alerts start going off that the CPU on the SQL Server is now pegged. It’s an all hands on deck situation that you need to figure out quick.
SQL SERVER – How to Find If Queries are Run in Parallel?
(Pinal Dave) Technology innovations over years have made personal computing and the infrastructure inside our datacenters even more powerful. Gone are the days when our laptops used to come with single processors and single cores.
#0359 – SQL Server – Script to reset a SQL Login
(Nakul Vachhrajani) A few days ago, we were changing the passwords of SQL Logins on our development SQL Server instances.
Pulling data from the error log
(Kenneth Fisher) The other day I was asked to pull a list of errors from the SQL Server log into a table for analysis. It seemed like something that others might find useful so I decided to post what I came up with.
What to do when your SQL CPU is at 100%
(Derek Dieter) We’ve all had it happen, alerts start going off that the CPU on the SQL Server is now pegged. It’s an all hands on deck situation that you need to figure out quick.
SQL SERVER – How to Find If Queries are Run in Parallel?
(Pinal Dave) Technology innovations over years have made personal computing and the infrastructure inside our datacenters even more powerful. Gone are the days when our laptops used to come with single processors and single cores.
SQL Server 2016 Stretch Database
(derekewilson) One of the features in SQL Server 2016 that you will want to explore is the ability to store your historical data in the Azure cloud.
Ignore a warning on a dacpac reference at your peril
(Ed Elliott) I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one 2008. The 2012 project referenced the 2008 project as a “this database” reference and while this seemed like it worked, the reference in solution explorer had a little warning sign and
