Dead Data
What happens to the data of a company if it goes out of business? Steve Jones has a little experience and says it might not be as simple as you think.
Streaming Data Into SQL Server 2008 From an Application
Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.
Automate collection and saving of failed logins for SQL Server
I re-cycle my SQL Server log every night using sp_cycle_errorlog. However, before I do, I would like to capture all of the failed logins recorded. I have auditing turned on for failed logins, but I want to make sure that I capture those events into a table so I can report on. How can I do this?
SQL Server 2008 Developer Training Kit
The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.
SQL Server Encryption - Protecting Files at Rest
You have a few options for protecting your SQL Server data at rest. So far I haven't seen anything thing protects data in memory, and I'm not sure we ever will. After all, at some point it needs to be processed, joined, etc., and that can't happen if it's well encrypted.
The Sports Salary
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
The Sports Salary
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
The Sports Salary
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services
See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.
Decoding Micro-speak
MVP Brad McGegee spends a lot of time talking to people at Microsoft. He's learned how to interpret thier language, and understand what they mean when using certain terms.
Blogs
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...
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
Forums
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
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