In this edition of the SQL Server Mailbag, database expert Denny Cherry tackles reader questions dealing with concerns over downgrading from SQL Server Enterprise to Standard edition, installing SSIS on a second server and more.
2009-09-07
3,011 reads
The final part of the Security Audit series examines how to secure the Windows Server operating system.
2009-09-07
2,582 reads
In this tip, I am going to discuss how you can get started with SMO and how you can programmatically manage a SQL Server instance with your choice of programming language.
2009-09-04
3,737 reads
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-04
3,808 reads
This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.
2009-09-04
4,268 reads
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
2009-09-04
714 reads
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
2009-09-04
751 reads
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
2009-09-04
727 reads
Josef Richberg, a DBA with HarperCollins Publishers, has been selected by judges and the DBA community as winner of 2009’s Exceptional DBA Awards, sponsored by Red Gate Software. Freelance writer Bob Cramblitt spoke to Richberg about the role of the DBA and the importance of sharing knowledge with the community.
2009-09-03
2,015 reads
A new article that shows a brief example of the FILESTREAM feature in SQL Server 2008 from new author Hugh Thomas. It looks at creating objects for testing, and importing a sample image.
2009-09-03
5,575 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers