10 Steps to Securing your SQL Server
Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.
2007-09-22 (first published: 2003-04-03)
45,675 reads
Articles
A Bit About 64-bit
64-bit SQL Server is coming!! Are you ready for this new technology? Chances are most of you are like us in that you've never had a 64-bit machine around and you likely don't remember the transition from 16-bit to 32-bit. Do you even want to make the transition? Is it worth it? New author Robert Pearl brings us a first look at how the 64-bit version of SQL Server will differ from the 32-bit version.
2007-09-22 (first published: 2004-05-26)
29,363 reads
Access to SQL Server: The Upsizing Wizard
SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.
2007-09-22 (first published: 2005-02-22)
30,764 reads
Common Table Expressions in SQL Server 2005
The next evoution of T-SQL, which will be released in SQL Server 2005, contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Coming ever so closer to the SQL-99 specification with Common Table Expressions, new author Srinivas Sampath brings us an introduction to this new way of writing complex queries.
2007-09-22 (first published: 2005-03-02)
50,898 reads
Database Standards and Conventions
Having a good set of naming conventions for your SQL Server objects is one of the most vital things to a company. In the long duration of a business, it saves money and time as programmers are transferred internally and don't need to relearn object names. As learning curves lower, cost lowers. This article covers some of the conventions that Brian Knight uses and why he uses them.
2007-09-22 (first published: 2001-05-29)
28,210 reads
Encrypting Data With the Encrypt Function
One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.
2007-09-22 (first published: 2001-07-17)
34,059 reads
Help! My Database is Marked Suspect.
If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.
2007-09-22 (first published: 2004-03-31)
59,212 reads
Implementing Encrypting File System (EFS) with SQL Server
EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.
2007-09-22 (first published: 2002-12-09)
32,411 reads
Periscope for SQL Server Discount
With a new version supporting SQL Server 2005, Periscopde for SQL Server is offering a 25% discount for SQLServerCentral.com members. This product helps with performance monitoring.
2007-09-22 (first published: 2005-10-05)
3,855 reads
SQL Server 2000 SP 3: What's New in Security
Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
2007-09-22 (first published: 2003-06-05)
30,105 reads
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers