Database Snapshots – A view of database at a specific point in time
Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting...
2012-12-11
875 reads
Basit's SQL Server Tips
Why SQL Server security matters: A case study
Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data...
2012-12-02
808 reads
XML Support and SQL Server
Checkout my article here, in which I discussed the fundamentals of XML technologies.
This article is published on SSWUG.org.
2012-12-02
631 reads
Planning for ETL solution
Checkout my article here, in which I talked about the basic steps that are requried to plan an successful ETL...
2012-12-02
706 reads
How to migrate a SQL Server database to a lower version
Problem
After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application...
2012-11-15
1,901 reads
SQL Server 2012 Installation Guide
Reblogged from Basit's SQL Server Tips:
This article walks the user through installation of SQL Server 2012 on a Windows Server...
2012-11-11
1,271 reads
SQL Server Database Consolidation
The database expansion costs money, not just software licenses. It costs money in maintenance and hardware, and also impacting businesses...
2012-11-11
1,072 reads
SQL Server Service Broker error database cannot be enabled
Problem
The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the...
2012-10-24
3,648 reads
Getting Started with Partially Contained Databases
Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated...
2012-10-24
877 reads
SQL Server Locking Overview
Locking is a necessary part of transaction processing when working in a multi-user Online Transaction Processing (OLTP) environment. You use...
2012-10-21
12,265 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...