Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Interviewed on Channel 9

Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.

https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player


Filed under: Blog Tagged: DevOps, speaking, syndicated

Read more

0 comments, 97 reads

Posted in The Voice of the DBA on 9 December 2016

Easily Move Databases with Copy-SqlDatabase

One of the things that people have asked to be implemented for many years is an easy way to copy databases. SSIS has the Copy Database Task, but that has been problematic over time. As a result, while easy, it’s cumbersome to take a backup of a database, copy it… Read more

0 comments, 64 reads

Posted in The Voice of the DBA on 9 December 2016

Why won’t my SP work THIS time?

Why won't my SP work? I did this exact thing. You're never too old to do something like this.

The post Why won’t my SP work THIS time? appeared first on The MidnightDBA Star-Times.

Read more

6 comments, 120 reads

Posted in SQL Awesomesauce on 9 December 2016

In Memory OLTP – 2

Good day everyone , In last post

In Memory OLTP – 1

we saw the what is In Memory OLTP and what are the requirements for that. In This post I will show you the demo of how we get performance gain.

The scripts (demo ) i will be using… Read more

0 comments, 51 reads

Posted in SQLSERVERS’dba on 9 December 2016

Friday Reading 2016-12-09

One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to get my family, I’ll be reading…

Mr Robot killed the Hollywood hacker
Article on MIT Tech Review about how hacking is depicted in Mr Robot.

Understanding Scan Count 0, Logical… Read more

0 comments, 70 reads

Posted in The DBA Who Came In From The Cold on 9 December 2016

NOLOCK

NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and MAY cause blocking. I used to think that a NOLOCK (which is the same as read uncommitted) hint actually meant … Continue reading

Read more

1 comments, 189 reads

Posted in All About SQL on 9 December 2016

What keeps clearing my query stats?

I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface Pro 3 dev instance about every 30 to 60 seconds.

I opened object explorer to check if any jobs were running in SQL Agent that may be running DBCC FREEPROCCACHE Read more

0 comments, 118 reads

Posted in Confessions of a Microsoft Addict on 8 December 2016

What Port Should I Use?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This is a quick post on checking the port for your SQL Server instance. It’s in line with Tim Ford’s request for simple, beginning blog posts this… Read more

2 comments, 130 reads

Posted in The Voice of the DBA on 8 December 2016

Fixing Data Migration Assistant timeouts

I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the things I like best about it is that unlike the old Upgrade Advisor it doesn’t have to be run on the server being upgraded. You can run it against… Read more

0 comments, 97 reads

Posted in SQLStudies on 8 December 2016

Query Store - Part 4 - Find the plans and queries forced by Query Store

As most of you know, one of the most fundamental uses of query store is to force query plans. Unlike query hints, Query store doesn't demand code a change nor it is complex to implement like plan guides. One can force a plan without make a query / code change…

Read more

0 comments, 62 reads

Posted in SQL and SQL Only on 8 December 2016

This Week in Data – Episode 15 (Why People Are Flocking to SQL Server)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss why companies are deciding to move to SQL Server.

In our industry, we often hear people talking about being on or migrating to… Read more

0 comments, 85 reads

Posted in Devin Knight on 7 December 2016

SQL in the City is coming next week

Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free and doesn’t require any travel. You can watch the event live from the comfort of your office chair.

In the many years that we’ve run SQL in the City, we’ve… Read more

0 comments, 111 reads

Posted in The Voice of the DBA on 7 December 2016

SQL Server & Containers – Part Four

In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of SQL Server in containers.

This post follows on from Part Three in which we uploaded a custom image to the docker repository.

The three previous posts have all been… Read more

1 comments, 115 reads

Posted in The DBA Who Came In From The Cold on 7 December 2016

TDE Recovery

This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can I not get involved with this one? I have been blogging for about a year now and have covered … Continue reading

Read more

2 comments, 265 reads

Posted in All About SQL on 7 December 2016

Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp

In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a directory On a Linux server, by default, the group owner of a file or directory is the primary group of the user who created the file directory. And it is…

Read more

0 comments, 81 reads

Posted in SqlServerZest.com - SQL in simple style on 7 December 2016

Oracle Linked Server errors

Stuck with the below error right now..any ideas

Trying to pull data from Oracle view using linked server and getting below error. It was only when I try with particular Oracle instance, when I try to pull data from other instance using the same view it is working fine.

Any…

Read more

0 comments, 98 reads

Posted in SQL Articles by Nani on 7 December 2016

A Python SQL Server App

I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I’ve done a little Python and I used Windows, I chose that option.

The page looks to walk… Read more

0 comments, 206 reads

Posted in The Voice of the DBA on 6 December 2016

Actual Chats: RIGHT OUTER joins in the wild

Colleague:
I think I just encountered my first Right join
*shocked* 
Me:
huh. weird.
a rare Right Join has appeared!
Colleague:
catch it!
Me:
You use ON. It's super effective! 
Colleague:
haha
how often do you see them? 
Me:
I've used RIGHT join maybe twice in 10 years. 
Colleague:
lol

Read more

0 comments, 79 reads

Posted in SQL Tact on 6 December 2016

TSQL Tuesday #85 Invite – Backup and Recovery

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought we might talk about security.

No. Wait. Sorry, that was last time. This time I want to hear about backup and recovery.

Backups are one of the most common… Read more

4 comments, 134 reads

Posted in SQLStudies on 6 December 2016

Power BI Custom Visuals Class (Module 28 – Sankey)

In this module you will learn how to use the Sankey Power BI Custom Visual.  The Sankey is a type of diagram that visualizes the flow of data between a source and destination.

Module 28 – Sankey

Downloads

Read more

0 comments, 82 reads

Posted in Devin Knight on 6 December 2016

Older posts