Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-06
3,521 reads
The Right Attitude to be a Mentor
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
2010-01-06
2,205 reads
Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-06
534 reads
Picking a Blog Platform
For the past couple years I’ve been using Community Server for blogging, only because that’s the platform that’s been part...
2010-01-06
1,155 reads
Primary Key Discovery
As a part of my DB documentation process for a large database, I needed a method to quickly show me...
2010-01-05
727 reads
How to obtain RecordCount (or Number of cases) from a DMX query
This one caught my eye on the Data Mining Forum and it is not the first time that this one...
2010-01-05
2,638 reads
Sometimes the tools don’t work
We have a lot of administrative tools for SQLServerCentral that are available online. Most of the work I do can...
2010-01-05
400 reads
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-05
546 reads
PASS Summit – Where to Hold it in 2011
Bill Graziano posted some thoughts about the merits of East Coast vs West Coast placement of the Summit. He did...
2010-01-05
376 reads
New Blog Feed URL
Not easy to find yet on the new site, you can find it at http://www.sqlandy.com/feed/.
2010-01-05
317 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
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...
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