May 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check

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…
Read More

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…
Read More

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…
Read More

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.

Read More

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:

Read More

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…
Read More

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…
Read More
Previous 1 … 138 139 140 141 142 143 144 … 536 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version