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

SQL SERVER – ReadOnly Databases with ReadOnly File Attribute

March 6, 2015

As part of continued series of ReadOny databases, the earlier blog had an interesting comment that read as some people were getting errors of 5120 and others. This got me curious and was in the pending list of solutions in some way. One of the readers had mailed me saying,…

SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070

March 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Using Raw Files in SSIS. Linchpin People are database coaches and wellness experts for a data driven world. In this 70th episode…

SQL SERVER – Database Stuck in “In Recovery” Mode After Restart

March 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Read this blog and I am sure it will bring some instances in your environments. This is one of the common issues I have observed while working with SQL Server from long time now. In this blog we will discuss little details about the issue and possible action you might…

SQL SERVER – Security Conversations and Notes with a DBA

March 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

One of the great things about working in Pluralsight is that I get to meet a lot of people (trust me on this). I am lost for words when it comes to how my day job helps me in achieving some of the coolest things presentations at a number of…

Hey DBA – Protecting a Proactive Attitude – Notes from the Field #069

February 26, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a 69th episode of Notes from the Field series. Mike Walsh is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. He is always looking for an opportunity…

SQL SERVER – Storing Data in Hindi, Chinese, Gujarati and Tamil (or any other) Language in the Same Table

February 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation

Long time ago, I have written a blog which talks about multi language support available with SQL Server. SQL SERVER – 2005 – Multiple Language Support I have been getting below questions on regular basics and it still baffles me: How do I pass Hindi parameters in SQL Server procedure…

SQL SERVER – COLUMNSTORE and COLUMNSTORE_ARCHIVE data compression

February 23, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Index

In earlier blogs on “Fundamentals of Columnstore Index”, I took a simple approach on taking a tour of how to create a simple Columnstore index. Having said that, SQL Server 2014 supports columnstore and columnstore archival compression for columnstore tables and indexes. Columnstore tables and indexes are always stored with…