Introducing Change Tracking in SQL Server 2008
Yan Pan demonstrates how to set up Change Tracking on a table in the AdventureWorks2008 database and how to query the changed data.
2009-06-23
3,681 reads
Articles
Maintaining high availability of SQL Server VMs
Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.
2009-06-23
2,604 reads
Tips on Getting Hired – Part 2
Yesterday I posted Part 1 containing five ideas for those looking for work. Today I’m going to focus on what to do when you’re struggling to get interviews. Your chances of getting hired for any given job once you interview are perhaps 1 in 10 (an unscientific...
2009-06-23
2,333 reads
Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
2009-06-22
530 reads
Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
2009-06-22
509 reads
Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
2009-06-22
590 reads
Logging connection strings
If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing.
2009-06-22
3,641 reads
Using the OBJECT_SCHEMA_NAME function to return the schema name
I tend to do a great deal of meta-data (or is it metadata) mining from the system compatibility views and system catalog views in order to build dynamic ad-hoc T/SQL code to use for various administrative processes.
2009-06-22
3,158 reads
What I’ve Read and Recommend to Others – SQL Server 2008 Part 1
I read, a lot. I’ve been a prolific reader all my adult life. I use to split my reading between tech books and my regular relaxing reading but since I got into audio books several years ago I just pretty much read tech books now. Some times I’ll listen..
2009-06-22
2,905 reads
Grown Up Software
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
2009-06-21
745 reads
Blogs
“SQL Server Is Slow” Part 4 of 4
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
How to Install DBeaver and Connect to a PostgreSQL Instance
By gbargsley
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...
DBAs should never run SSMS under their everyday Windows account
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
Forums
Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Vector Datatype Dimensions
Comments posted to this topic are about the item Vector Datatype Dimensions
SQL Server DBA - Immediate need
Immediate need for a hands-on SQL Server DBA. This is a greenfield opportunity to...
Question of the Day
Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers