SQL Tips and Tricks Archives - Page 141 of 536 - SQL Authority with Pinal Dave

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

March 5, 2015

[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…

SQL SERVER – Script to Convert Date to Julian Dates

March 2, 2015

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

There are many methods to store date values. One of them is Julian date. It is a seven digit number where first four is the year part and the next three digits are the number of days from Jan 01.

SQL SERVER – FIX: SQL Server Not Starting – Msg 864, Level 16, State 1- Buffer Pool Extension Feature

February 28, 2015

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Server

Recently I got an email from one of the student who attended my SQL Server 2014 Pluralsight Course from last year, he was trying to use Buffer Pool Extension feature and got into some unique trouble. Here is the email from him:

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…