Build a SQL Cluster Lab Part 2
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by...
2019-11-04
24 reads
Blog Posts
Deadlocks – Azure SQL Database
Would you like to troubleshoot a deadlock in Azure SQL Database? To do this you probably will be after the deadlock graph. So does this mean that you need...
2019-11-04
140 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
17 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
8 reads
Resumable online index rebuild
continue on whats new SQL Server 2017 their is a great feature call resumable online index, means online index now has an option to PAUSE and RESUME or ABORT...
2019-11-04
140 reads
SQL Homework – November 2019 – SSMS built in reports
Time for some homework again. I know Pass Summit is this week so you may be a bit busy but ... Continue reading
2019-11-04
30 reads
SQL Server Stored Procedures vs Functions vs Views
Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....
2019-11-04 (first published: 2019-10-22)
3,028 reads
SQLSaturday Orlando Notes – Post Event Speaker Survey
One of the follow up items I have from the event was to poll speakers on what hotel they used (see my previous post). In jotting down some notes...
2019-11-04
28 reads
SSIS Scaleout: Cannot open certificate store on the machine
When attempting to connect a worker node to the current Master node of a SQL Server Integration Services (SSIS) Scaleout, for on-prem SQL Servers, if you receive the error:...
2019-11-04 (first published: 2019-10-22)
789 reads
Teams in SQL Clone and SQL Provision
SQL Clone v4 is out, and the big change is the addition of the Teams feature. I guess technically this is just for SQL Clone, which is included in...
2019-11-04
47 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers