How to secure SQL Server?

Databases are an important reservoir of sensitive information, and that is why it is important for us as a DBA...

Using SQL Server 2012 FileTables

Reblogged from Basit's SQL Server Tips:

SQL Server 2012 allows you to store file/directories in a special table called FileTable that...

(Mis)Using DBCC Page

In one of my presentations recently I was recommending DBCC CHECKDB on every database every day. I realize that isn’t...

A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan

I recently passed my MCTS 2008 Development (70-433).  Yay me!  That made my 3rd 2008 certification.  This one was probably the...

Why Tune Queries?

It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...

Last Weeks Top 10 “Reading” Links #2

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out...

SQL Server # TSQL to Convert STRING in PROPER format

Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...

Introduction to SQL Server at Christmas

There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...

Office 2013 BI and Mobility

I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about...

IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM

Dear Friends
Firstly, I want to say thanks for your support & liking my blogs that make it possible.
I like to share...