Save yourself from despair with full database documentation
Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases....
2012-03-29
2,744 reads
Contained Databases in SQL Server 2012
One of the problems with databases in SQL Server is the dependency of the database on various parts of the...
2012-03-29
2,015 reads
Importing data from Excel – using INSERT statements
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However,...
2012-03-29
3,327 reads
Error 18456 a little more friendly in 2012
While preparing a demo for a presentation, I generated a 18456 error in the SQL instance by selecting a non-existent...
2012-03-29
1,178 reads
Why I am excited about SQL Server 2012 (Part 2)
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
703 reads
I am looking for change
I am looking for a change. Yes, a change. This is the beginning of that quest. This blog will be...
2012-03-28
840 reads
Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,961 reads
SQL Server 2008 Diagnostic Information Queries (April 2012)
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,090 reads
Stress Thoughts-Part 3
It’s not fair. I hear it a couple times a day. Sometimes they are right, sometimes not, but it’s how...
2012-03-28
690 reads
TinyInt problem in SSAS
If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...
2012-03-28
1,622 reads
Blogs
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...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
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