(Vinod Kumar M) Using SQL Server Management Studio is something we do instantly after connecting to our mailing system everyday if we are a SQL Developer or SQL Administrator. Though this is a very common step, there can be optimizations we can make even in this mundane yet simple task. Let us look

(Ray Barley) SQL Server Data Tools (SSDT) comes with SQL Server 2012 and is the replacement for Business Intelligence Development Studio (BIDS). In the earlier tip Introduction to SQL Server Data Tools I covered what is referred to as “Project-Oriented Offline Database Development” in the MSDN docum

(Shaun J Stuart) I’ve been experiencing an intermittent problem with my automated backup testing routine for some time now. I would occasionally get a failure during a restore, but when I manually ran the exact same restore command, the restore worked without issue. Because my testing routine select

(Franco Lopes) In the last article we saw how we can call the report from the front end using the report viewer component of Visual Studio. In real time scenarios we usually want to view a customized report with the custom parameters. In this article we are going look at how we can pass parameters t

(Pinal Dave) Before you start reading this blog post, I strongly suggest you to read the part 1 of this series. It talks about What is Redundant Index. The story is a conversation between two individuals – Jon and Mike. They are different but have single goal learn and explore SQL Server.

Most employers understand that to get the most out of their staff, the work climate needs to be friendly, flexible and somewhat accommodating. Having a friendly atmosphere makes coming into the office more comfortable and exciting. People work with folks they know, like and trust. Good manager cr

(Scott Mattie) I am going to start a series on different database types for various data programs. (Microsoft SQL Server, MY SQL and Access) My goal here is to document the different data types and categories that reflect basic information about them.

(Joe Celko) Here is an in-depth look at an underused constraint, UNIQUE, that can increase the performance of queries and protect data integrity.

(Kenneth Fisher) We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working on servers that we aren’t familiar with. And that means that we don’t know where the backups are stored. So yesterday when I had to do an ad-hoc backup for a database o

(Manvendra Singh) Today, a developer reported that he is not able to create an index in our development environment and is getting this error: