SQL Server Archives - Page 53 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052

October 30, 2014

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 52th episode of Notes from the Field series. I am very happy that the journey which we started one year ago is a amazing milestone. In this 52 episode in the entire year we have learned a lot of new things from industry experts…

SQL Authority News – Embarcadero DB PowerStudio Promotion & Savings

October 27, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

If you are regular readers of this blog, you may be aware of that I use many different tools in my daily routine. One of them is DB PowerStudio for Embarcadero. The team has recently announced special saving for up to 51% when you buy the DB PowerStudio bundle. With…

SQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2

October 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Yesterday I wrote a blog post about SQL SERVER – How to Flip Value of Bit Field in SQL Server? . Lots of good suggestions I have received in response of the same. Here are a few different methods to flip value of a bit field suggested by my very…

SQL SERVER – How to Flip Value of Bit Field in SQL Server?

October 25, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

How do you flip bit field in SQL Server? Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field. Bit field can hold two different values zero (0) and one (1).…

SQL SERVER – Database Stuck in Restoring State

October 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Here is a one of the very common question I keep on getting via email. “I just restored all the backup files of my database, however, my database is still stuck in restoring state. How do I fix it?” Well, if you have already restored all the database, you can…

SQL SERVER – The Why of BIML – Notes from the Field #051

October 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 51th episode of Notes from the Field series. In one of the earlier blog post we discussed about BIML and lots of people asked what is actually BIML and why one should use it. If you have been reading this blog, when it is…

SQL SERVER – Search Records with Single Quotes – SQL in Sixty Seconds #075

October 22, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video

SQL Server Management Studio

Earlier I wrote two blog posts about Search Records with Single Quotes in two parts. Refer the blog posts over here. Search Records with Single Quotes Search Records with Single Quotes – Part 2 Though I had clarified that all the methods displayed in these two blog posts have the exact same…