Indexing Fundamentals
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,693 reads
Select * from * : Quick Tips
What? You want to see all of your data? Well do I have the script for you! New, Improved, Extra...
2013-11-20
463 reads
Triangle SQL Server User Group Wrapup
Tonight I had the pleasure of presenting remotely to the Triangle SQL Server Users Group. I presented my session entitled “Squeezing...
2013-11-20
629 reads
SQL Server 2008 Service Pack 3 Cumulative Update 14
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 14, which is build 10.00.5848. This Cumulative Update has...
2013-11-19
1,193 reads
SQL Server NorthEast – New Usergroup!!
SQLBits in Nottingham was where it all began. A short conversation on whether there were any plans for a SQL...
2013-11-19
837 reads
What should a candidate know about your company?
I had a great comment (Ryan McCauley’s) on yesterday’s post that led to a great conversation on Twitter. The comment mentioned...
2013-11-27 (first published: 2013-11-19)
2,067 reads
Create video presentations
I recorded my first video presentation and demo using the screen recording and video editing software called Camtasia Studio for Windows.
It’s...
2013-11-19
586 reads
Windows Azure Views
It’s kind of fun to see Azure development artifacts on display. I’ve posted about them before, a couple of times....
2013-11-19
877 reads
T-SQL Tuesday #48 Roundup
A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to give your thoughts on Cloud. Lots of interesting reads...
2013-11-19
10 reads
T-SQL Tuesday #48 Roundup
A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to give your thoughts on Cloud. Lots of interesting reads...
2013-11-19
21 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers