Locking Your Disk
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know.
2008-02-28
36 reads
Articles
Microsoft SQL Server 2008 - Change Data Capture – Part 2
Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.
2008-02-28
2,718 reads
The Stewardship Approach to Data Governance: Ch 7
This is the seventh article in a continuing series, and this installment discusses the tactical layer of the Data Governance Framework.
2008-02-28
1,423 reads
Coping with No Column Names in the SSIS OLEDB Data Source Editor
Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.
2008-02-27
7,437 reads
New Isolation Levels Available in SQL Server 2005
One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced.
2008-02-27 (first published: 2007-03-05)
3,652 reads
SQL Server 2008 - Table Valued Parameters
In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.
2008-02-27
2,499 reads
Writing Outer Joins in T-SQL
Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.
2008-02-27
7,220 reads
Ideas for SQLServerCentral.com
We're embarking upon a rebuild of the site and we're looking for input from those of you that use the site.
2008-02-26 (first published: 2007-02-26)
1,732 reads
Snapshots - Part 1
Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.
2008-02-26
2,627 reads
Using the ReportViewer Control in a WebForm with Parameters
A short article by Darren Herbold, reporting services trainer and consultant that shows how you can easily use a Report Viewer on a web page.
2008-02-26
11,530 reads
Blogs
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers