Shifting of the Tides and my Career
Watching my career progression over the last year, an outside observer would think that I’m playing career path hop-scotch, or...
2013-06-15
548 reads
Reblog: June 7 to June 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-14
876 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for Pragmatic Works. There were over 500 attendees! The abstract...
2013-06-14
1,276 reads
Few thoughts and updates
Few of my regular readers may have noticed I am not actively blogging @ SSC at frequent interval.
There is a reason behind...
2013-06-14
1,177 reads
Colorado SQL Events : June 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-06-14
885 reads
Improving performance by using SET STATISTICS IO
When I started using SQL Server the company I was working for at the time had no skill in this...
2013-06-14
2,858 reads
The Side Effect of NOLOCK (video)
A while back I put together a blog post on the side effect of NOLOCK. Today I thought I’d push...
2013-06-13
544 reads
Security Questions: Migrate Logins Between Servers
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-13
583 reads
Levels in IT consultancy
The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...
2013-06-13
1,057 reads
Book Review: Instant Creating Data Models with PowerPivot How-to
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...
2013-06-13
599 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