SQL Server

Pro Members SQL Server Standard Members

Does my SQL Server database use any Edition specific features?

Does my SQL Server database use any Edition specific features? Author: Basit A. Farooq Introduction Today, I received a phone call from a friend who is thinking to downgrade the database hosted in SQL Server 2008 Enterprise Edition to SQL Server 2008 Standard Edition. He made me question whether this type of move is possible and is there any way...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 triggers

Tips for using SQL Server 2012 triggers Microsoft SQL Server 2012 introduces many new useful stored procedures, functions and operators. Some actions you can perform without these new features, but usually using them provides more easy and effective way to accomplish the same goal. In this article, you can find some tips to use triggers in SQL Server 2012. Try...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Snapshots – A View of Database at a Specific Point in Time

Database Snapshots – A view of database at a specific point in time Author: Basit A. Farooq Introduction Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting a consistent view of data at a certain time. So in other words we can say that it is a static, read-only...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Query Notifications

Troubleshooting problems with SQL Server 2008 R2 Query Notifications If you have problems with SQL Server 2008 R2 query notifications, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 query notifications bugs were fixed in SQL Server service packs, you should install the latest SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Administration versus Database Administration

Data Administration versus Database Administration By Craig S. Mullins What is data administration (DA) and what does it have to do with database administration (DBA)? Well, in this day and age, the term “data administration” is not used nearly as commonly as it was just a few years ago. Instead, we hear terms like data governance or data architecture. But...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

XML Support and SQL Server (Part 1)

XML Support and SQL Server (Part 1) By Basit A. Farooq XML fundamentals Beginning with SQL Server 2005, Microsoft improved and expanded its eXtended Markup Language (XML) support, the activities that previously required complementary products now have native support. Native XML commands and utilities have been expanded to include new features. In this article, I’ll give you an overview of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Design: From Logical to Physical

Database Design: From Logical to Physical By Craig S. Mullins A proper database design cannot be thrown together quickly by novices. What is required is a practiced and formal approach to gathering data requirements and modeling data. This modeling effort requires a formal approach to the discovery and identification of entities and data elements. Data normalization is a big part...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Planning for ETL

Planning for ETL solution By: Basit A. Farooq Introduction Because any business intelligence (BI) mainly deals with the data, without doubt, the solution includes an extraction, transformation and loading (ETL) components linking the data sources and destinations. After gathering business requirements, the first step in the ETL component design is to plan the data transfer and staging solutions that support...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 System Stored Procedures

Troubleshooting problems with SQL Server 2008 R2 System Stored Procedures If you have problems with SQL Server 2008 R2 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 system stored procedures bugs were fixed in SQL Server service packs, you should install...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Database Mail

Troubleshooting problems with SQL Server 2008 R2 Database Mail If you have problems with SQL Server 2008 R2 Database Mail, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Database Mail bugs were fixed in SQL Server service packs, you should install the latest SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register