White papers, DMVs and Monitoring Concepts
According to Jason Strate (SQL Server MVP) there are 5 white papers ever SQL Server DBA should read. Considering my...
2013-06-01
1,024 reads
Power View for Multidimensional Models Released
As a followup to my blog Power View for Multidimensional Models – Preview Available, the final version is now available via...
2013-05-31
1,835 reads
PC Sales Declining
About 3 or 4 years ago I was talking with my wife and a colleague of hers that worked in...
2013-05-31
1,399 reads
Thoughts About The Nail
The other day Grant Fritchey (Blog | @GFritchey) linked out the video below. It’s a quick little video, that isn’t about the...
2013-05-31
1,325 reads
Reblog: May 24 to May 30
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-31
1,171 reads
TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,532 reads
SQL and Relational Theory
Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the...
2013-05-31
1,005 reads
Building a SharePoint 2013 BI Demo Environment Part 2 – Building the VM
In this blog post I’ll explain how I build the VM and VHD for my virtual demo environment. I use...
2013-05-31
1,714 reads
Exploring a Database in Azure
After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied...
2013-05-30
1,653 reads
SQL- Setup and Configure Backup Report – Step by Step Approach – All listed SQL Instances
One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying...
2013-05-30
1,541 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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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