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.
The final part of the Security Audit series examines how to secure the Windows Server operating system.
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.
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.
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
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.
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.
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.
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.
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.
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
GateHouse Lititz PA got a much-needed renovation after years of service to make it...
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers