2020-05-04
101 reads
humor
2020-05-04
655 reads
2020-04-01
769 reads
Cursors Without Performance Penalties
Imagine how coding might take place if cursors were as efficient as complex SELECT statements.
2020-04-01
335 reads
SQL v.Next Gets Native Python in SQL Server
The next version of SQL Server is in early preview and there is a new feature that is going to be very useful for large enterprises that want to run Big Data Clusters and perform additional data science tasks. Instead of embedding Python code in a string and submitting it to the Launchpad engine, we […]
2020-04-01
4,074 reads
2019-12-31
803 reads
2019-12-25
956 reads
The DBA's Twelve Days of Christmas
On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]
2019-12-24
182 reads
2019-11-28
695 reads
2019-10-31
238 reads
Blogs
Creating a SQL Clone Agent and a First Image
By Steve Jones
In a previous post, I set up the SQL Clone server. This is really...
Availability Group issues fixed with Alerts
Learn how to use the SQL Server Agent Alerting system to capture Availability Group...
Availability Group issues fixed with Alerts
Learn how to use the SQL Server Agent Alerting system to capture Availability Group...
Forums
Why aren't the backups working?
You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I...
Cannot insert duplicate key in object
In table tUSERI primary key was added in the column [Email]. I deleted a...
Random excessive CPU consumption
Hi all. I'm in a bit of a quandary with one of our Analysis...
Ask SSC