Database Mail, Part 2 - SQL School Video
Database Mail is an essential part of administering SQL Server for most people. MVP Andy Warren brings us part 2 of how to set up this subsystem.
Failing SQL 2005 Cluster Installation because of too many cpu's
A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.
Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
Object Grouping Best Practices: Using Schemas for Logical Separation
You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,
Service Pack 2 Uninstall Not Possible for SQL Server 2005
You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.
Top five tips for SQL Server developers
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.
Basically Available, Soft State, Eventually Consistent
The use of non-relational databases is a fascinating topic but they will remain special-purpose and are not competing with SQL-based relational databases.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
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