SQL Server Developer tools survey
Participate in an online survey on SQL Server Developer Tools for a chance to win one of ten $100 Amazon vouchers.
Scripting SQL Server databases with SMO using EnforceScriptingOptions
Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.
Software Projects: the important boring bits
Phil Factor on the sort of boring expertise that will help you thrive as a consultant.
We Still Need Human Judgment
Computers aren't necessarily more infallible than humans, and they aren't necessarily even going to make better decisions. We still need humans in the decision process.
How to troubleshoot SSL encryption issues in SQL Server
Tibor Nagy explains how to find the root cause of SSL encryption configuration problems in Microsoft SQL Server.
Overcoming Proposal Objections
We have all had our innovative solutions and proposals shot down by leads, managers and directors. This article addresses some of the causes and tips to improving the success rate for getting your ideas into the priority list.
What, When and who? Auditing 101
In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.
The SQL Scrabble Puzzle
An enhancement to a Phil Factor puzzle gives you a chance to play scrabble in T-SQL.
Webinar: Performance Tuning .NET & SQL Code Using ANTS Performance Profiler
In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.
Monitor Database Growth and Usage
Create a repository of all your database devices and stay informed about changes in their size and usage.
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Forums
Having some performance issues with linked server query
When I run my query from DW, which uses a linked server, it times...
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers