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

Latest Blog Posts

Steps to reset sa password of SQL Server instance

Connect SQL Server Configuration Manager to set startup parameters to start SQL server in single user mode.

Click all programs and click on SQL Server, go to Configuration Tools folder and click on SQL Server Configuration manager.











Right click on SQL Server and click properties. Click on Startup Parameters tab.…

Read more

0 comments, 60 reads

Posted in SQL Articles by Nani on 10 December 2016

Analysis Services and Power BI: Time-travel, Space-warping and Teleportation

As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation.  It is one that I have had for eighteen years.  The audiences change and the technology implementations are a little different over time, but the essential conversation is still the…

Read more

1 comments, 71 reads

Posted in SQL Server BI Blog on 10 December 2016

Linux – How to generate and configure SSH Key authentication to connect to a remote system

Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today I will walk you through how we can achieve this in 3 simple steps For this demo I will be configuring SSH key authentication for the user account accountsguru…

Read more

0 comments, 86 reads

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

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, 215 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, 112 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

8 comments, 182 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, 74 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, 86 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

3 comments, 659 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, 170 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, 147 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, 107 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, 72 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, 176 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, 138 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, 155 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, 298 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, 88 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, 104 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, 228 reads

Posted in The Voice of the DBA on 6 December 2016

Older posts