File Extensions for SQL Server Database Files
I was reading an article over the weekend where the author pointed out that the standard naming convention for SQL...
2012-06-18
1,665 reads
The Side Effect of NOLOCK
Have you ever been told that you should use NOLOCK? I have, and its usually been with OLTP systems where...
2012-06-18
1,992 reads
Tabular query modes: DirectQuery vs In-Memory
When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with...
2012-06-18
13,929 reads
Determine Index Fragmentation in a SQL Server Database
Index fragmentation can adversely affect query response time. When accessing data through an index, SQL Server must read each page...
2012-06-18
9,156 reads
Login failed for [SQLSTATE 28000] (Error 18456) the step failed
AdvertisementsLogin failed for [SQLSTATE 28000] (Error 18456) the step failed
When you query the data from another SQL server (Linked server)...
2012-06-18
53,617 reads
Monday Morning Mistakes: Connecting to Wrong Environments
Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got...
2012-06-18
2,328 reads
Holiday
Sort of.
I’m off for a week to Camp Alexander near Pikes Peak for Boy Scout summer camp. My 13year old...
2012-06-18
850 reads
Colorado SQL - June 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-06-18
772 reads
Washington DC in the Summertime
As I mentioned in my post last week I was fortunate enough to visit Washington DC a week or so...
2012-06-18
729 reads
Failover consederations on Database Mirroring
These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring....
2012-06-18
1,238 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
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I