Encryption Keys Matter
Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.
2016-09-13
79 reads
Editorials
Ignoring Database Version Control
Steve Jones thinks version control is important, even for databases.
2016-09-12
155 reads
Teaching a dog to sing
To survive the inevitable downturns in the IT industry, Phil Factor argues that a IT manager needs to take time to maintain technical skills. It is not enough to understand development; you have to be able to do it.
2016-09-12
111 reads
Impressive Accomplishments
What things impress you most about potential candidates. This week Steve Jones asks the question to try and understand what types of activities data professionals might consider.
2016-09-09 (first published: 2013-02-15)
267 reads
Practicing Deployments
Amateurs practice until they can get something right. Professionals practice until they don't get things wrong. How should we handle our deployments?
2016-09-07 (first published: 2013-02-12)
392 reads
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)
2016-09-05 (first published: 2008-03-12)
305 reads
Towards a Single Management Stack
Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.
2016-09-05
79 reads
The Copy Cat Poll
This poll asks about copies, specifically those of your databases. How many do you keep around? How much extra storage does this cost? Steve Jones thinks that most organizations have quite a few copies, which can use a lot of resources.
2016-09-02 (first published: 2012-08-03)
189 reads
Time Off
Finding a balance between work and life away from work is hard, but one good way is with periodic vacations. Today Steve Jones notes that some people don't take their vacation, which he sees as a problem.
2016-09-01 (first published: 2012-08-20)
267 reads
Avoiding Stored Procedures
This week Steve Jones argues against stored procedures. Is it a good argument or do want to stick with your stored procedures.
2016-08-30 (first published: 2012-08-13)
1,084 reads
Blogs
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...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Forums
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
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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