Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.

The GDR patch

Download SQL Patch Info

This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.

Lax Security - Database Weekly (June 22, 2009)

This week Steve Jones talks about database security, or the lack thereof, in today's world.

How Would You Rate This? - Database Weekly (Dec 29, 2008)

Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?

Versions of Disaster

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.

Versions of Disaster

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.

Versions of Disaster

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.

RE: Assigning a value to a variable, SET or SELECT ?

To sum it up very briefly - both is allowed, SET is recommended and SELECT is more efficient and more flexible :-).I mostly use SET only when setting fixed value of one variable (SET @param = 1) and SELECT when doing a select to find the value to be assigned, or when setting several variables at […]

RE: How to Deal with PK/FK In case of Insert/Update

An approach I used on a weekly data load a while back might be useful: The data we received was, essentially, a change log from the true owner of the data. We might see several records with the same primary key at various points within the file. Sounds similar to your situation. I set a […]