SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users
Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy...
2012-07-30
1,439 reads
Video Enable PowerPivot Add-in
This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable...
2012-07-30
1,632 reads
SQL Server : Dedicated Administrator Connections
Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...
2012-08-01 (first published: 2012-07-30)
3,759 reads
How to move master and resource system databases?
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,887 reads
The effects of an SSD on SQL Server Performance
I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...
2012-07-29
5,693 reads
transparent data encryption steps
In this blog post I show steps that are needed to enable Transparent Data Encyption on a SQL Server 2012...
2012-07-28
1,581 reads
reconfigure vs reconfigure with override
You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In...
2012-07-28
2,327 reads
SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint
This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing...
2012-07-28
974 reads
Learning solid SQL Server and Business Intelligence skills through online training
I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL...
2012-07-28
1,658 reads
SQL Server 2008 R2 Service Pack 2
Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through...
2012-07-28
2,359 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers