SQL Server vs. JET
This past week the Exchange 2010 team admitted they had tried SQL Server as a storage platform for Exchange 2010, but then discarded it. Steve Jones wonders why this was the case. Is SQL Server not good enough?
Certification High School
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
Certification High School
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
Certification High School
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
Help Me Name My New Blog
I am in the process of creating a new blog, but I am having difficulty coming up with a good name. I would like to go with a Hawaii-based theme on the blog, so a Hawaii-based name would be great.
Retaining historical index usage statistics for SQL Server - Part 3
In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.
Using the Resource Governor
SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.
A Deadlock Occurrence and Resolution
This article gives an example of a deadlock occurrence and the resolution steps taken. (Republished from 2008).
Building Your Brand at Work?
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
Building Your Brand at Work?
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
Blogs
macOS Tahoe breaks SQL Server on Docker containers on Apple silicon
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
From Firefighting to Future‑Building: SQL Server 2025 and the New DataOps Mindset
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
Forums
Extract from sql.to multiple sheets
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers