Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Monday, December 30, 2019

Top 10 posts from the last decade

›
As we finish the tumultuous 2010s and are ready for the roaring 2020s, I decided to take a quick look at the ten most viewed posts from th...
Wednesday, October 30, 2019

SQLSTATE 4200 Error 666 and what to do.

›
This morning I was greeted by the following message from a job email The maximum system-generated unique value for a duplicate group wa...
2 comments:
Wednesday, March 20, 2019

Some numbers that you will know by heart if you have been working with SQL Server for a while

›
This is just a quick and fun post. I was troubleshooting a deadlock the other day and it got me thinking.... I know the number 1205 by h...
5 comments:
Wednesday, May 16, 2018

Azure SQL Data Warehouse, Azure SQL Database and SQL Server sessions from the Build 2018 conference

›
The Build 2018 conference happened last week, I decided to put all the Azure SQL Data Warehouse, Azure SQL Database and SQL Server sessi...
Monday, April 24, 2017

How to shut down SQL Server

›
The question how to shutdown SQL Server came up at work last week, I figured it would be a nice topic for the newer DBAs and SQL Server prog...
Friday, December 09, 2016

Connecting to SQL Server when your default database is not available

›
One of our database on the development went in suspect mode today. This database was the default for a bunch of logins.  These people could...
1 comment:
Wednesday, November 16, 2016

SQL Server 2016 SP1 released, SQL Server vNext available for download

›
Today Microsoft announced the CTP of the next version of SQL Server, you can download it here  https://www.microsoft.com/evalcenter/evaluat...
Friday, October 28, 2016

Some cool SQL Server announcements SQL Graph, Adaptive Query Plan, CTP1 of SQL vNext, SQL Injection detection

›
There were a bunch of cool announcement at the SQL QA and chalk talk sessions at the PASS Summit Here are the people presenting th...
2 comments:
Wednesday, September 28, 2016

If you are going to PASS Summit 2016, build your schedule today

›
If you are going to the SQL Server Pass summit this year, you can start building your schedule already. Don't wait too long because so...
Sunday, February 21, 2016

How to store twitter search results from R into SQL Server

›
I was messing around with R and grabbing twitter searches from within R, after that I decided to store the result in a csv file. Instead of ...