SQL Server upgrade paths: What to do before, during, after upgrading
Creating SQL Server upgrade paths from one version to another is a task that every database administrator is eager to...
2013-08-06
762 reads
Guide to SQL Server Table Indexes (Part 3)
Checkout the part-3 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-08-06
557 reads
Guide to SQL Server Table Indexes (Part 2)
Checkout the part-2 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-08-06
540 reads
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-08-06
940 reads
Understanding Data Normalization
Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases....
2013-08-06
567 reads
Five Weeks Until SQLSaturday #232 In Orlando
Time has flown by and we’re just five weeks from SQLSaturday #232 on September 14th, 2013. It’s a time of...
2013-08-06
565 reads
Why use a SSAS cube?
What are the advantages of using SSAS Cubes over a regular data warehouse for reporting? Note I’m not asking why...
2013-08-06
1,674 reads
OT: privacy
I had a very unpleasant experience a while back when I was commenting anonymously on a web site (not SQL...
2013-08-06
596 reads
Ebooks From The Library–Overdrive Media Console
Recently I installed the Android version of the Overdrive Media Console on my Nexus 7. It’s a free app. Install...
2013-08-06
790 reads
Deadlock – A quick, easy view
Deadlocks are rough to work with. Here are the scripts I use to capture deadlocks, find which ones are reoccurring,...
2013-08-06
2,091 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers