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
874 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
630 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,899 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,071 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,635 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,263 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers