Tags » SQL Server

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

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. 747 more words

SQL Authority

SQL SERVER - ReadOnly Databases and Notes Using Snapshots

This seems to be the third week that I am writing about ReadOnly databases, this blog is in continuation of last weeks notes. When I wrote the notes from last week, one of my blog reader said if it is possible to get the ReadOnly error without making the database into a ReadOnly database. 457 more words

SQL Authority

SQL SERVER 2012 DATEPART FUNCTION

/* DATEPART FUNCTION USING SQL SERVER 2012 SSMS */

­­ALRIGHT, WE WILL BE LOOKING AT THE DATEPART FUNCTION IN SQL SERVER TO DISPLAY PART OF… 62 more words

2012

Debuting Cleaning House - Indexing Edition

Five weeks ago, my good friend Gina Meronek contacted me about MADPASS. Seems their scheduled speaker for February had to cancel, so they were trying to find someone to fill the spot. 217 more words

SQL Server