Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Include File Name in Content Using Power Query

When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name in the resulting table. For example, in Analyzing Baby Names using Power BI I posted recently, the file name contains year that I needed to include in the table. Here’s… Read more

0 comments, 665 reads

Posted in Sam Vanga on 21 July 2015

PSSDiag Configuration Manager – A Companion for SQLNexus

Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The engineer will typically send you a self-extracting exe file with instructions to unzip the file on the server and run the pssdiag.cmd file to collect data while you reproduce your issue. Afterwards, you’re supposed…

Read more

0 comments, 91 reads

Posted in Everyday SQL on 21 July 2015

Consequences of wrong database autogrowth settings

In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re going to talk about database files settings and their autogrowth settings. From the first glance this seems to be an easy question. But in reality it may cause serious issues… Read more

0 comments, 102 reads

Posted in Forrards Group Database Blog on 21 July 2015

Keep your environments in-sync and your upgrade scripts fresh

Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind to ensure we do not break existing databases.

Why is it important?

When you upgrade an application you just compile and…

Read more

0 comments, 71 reads

Posted in Ed Elliott's Sql Developer Blog on 21 July 2015

Speaking about Columnstore Indexes at PASS Performance Palooza

The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance sessions by great speakers from all around the world.

I have the honor to speak in this year’s Performance Palooza, which will take place this Thursday, July 23.

I… Read more

0 comments, 73 reads

Posted in Matan Yungman on 21 July 2015

Azure SQL Database – Link User to Login

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

I created a login for an Azure SQL Database, but couldn’t log in. I would get this message, which makes perfect sense.

Just… Read more

0 comments, 139 reads

Posted in The Voice of the DBA on 20 July 2015

The SQL Saturday Crazy Train hooks up a caboose!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more

0 comments, 86 reads

Posted in A Discussion of SQL Server-Related Topics on 20 July 2015

Pre-Compare & Pre-Deployment Scripts to SSDT

When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the dacpac and database has been deployed. The process looks like:

  • 1. sqlpackage.exe compares dacpac to database
  • 2. sqlpackage.exe generates a deploy script
  • 3. sqlpackage.exe runs pre-deployment script
  • 4. sqlpackage.exe runs…

Read more

0 comments, 89 reads

Posted in Ed Elliott's Sql Developer Blog on 20 July 2015

SQL Server Management Studio – Footloose and Fancy Free

That’s right. There’s been a divorce. SQL Server Management Studio (SSMS) has been divorced from the server product. In fact, Microsoft is inviting you to the new SSMS coming out party.

I’m pretty excited about this. While I’m very comfortable in SSMS, to a large degree, it’s like that… Read more

3 comments, 114 reads

Posted in The Scary DBA on 20 July 2015

I’m Speaking! Edmonton SQL Server User Group

I am honored to be speaking at the Edmonton SQL Server User Group.  I always find it humbling to be asked to present and I thank the group for the opportunity.  My travel budget will not allow for me to be onsite for this meeting, so this will be… Read more

0 comments, 73 reads

Posted in John Morehouse | on 20 July 2015

Orlando SQL Saturday Precon – Transform and Visualize Data with Power BI

I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturday for the first time in many years. Then this weekend, I found out that I will also be delivering a full day Pre-Conference on Friday October 9, Transforming and Visualizing Data with Power… Read more

0 comments, 705 reads

Posted in SQLDownSouth on 20 July 2015

The Database Corruption Challenge

For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes today and even though I haven’t been able to take part in all of them, I have thoroughly enjoyed working through these challenges.

DBAs don’t often get… Read more

1 comments, 191 reads

Posted in The DBA Who Came In From The Cold on 20 July 2015

How to close all active database connections in one shot?

While trying to restore SQL Server database or do any other actions which require exclusive database access you may face with the following error:

Exclusive access could not be obtained because the database is in use.

Here is a quick solution which is much handier than killing all connections manually… Read more

6 comments, 569 reads

Posted in Forrards Group Database Blog on 20 July 2015

Filtered Index restrictions and Kendra Little’s Index Quiz

A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had to give them a shot and while I was somewhat disapointed in my scores on a few over all they were a lot of fun.… Read more

0 comments, 1,358 reads

Posted in SQLStudies on 20 July 2015

SQLSaturday Orlando 2015–Classes on Thursday and Friday for Even More Learning

We have a solid tradition here in Orlando of offering some all day classes the Thursday and Friday before SQLSaturday. It started way back at #1 when we brought Joe Celko to town! It’s a way to give our local community the chance to do some deeper learning at a… Read more

0 comments, 84 reads

Posted in SQLAndy on 20 July 2015

SQL Server Polybase (2016)

What is SQL Server Polybase?

Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage.  This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats… Read more

0 comments, 214 reads

Posted in Business Intelligence and Enterprise Architecture on 20 July 2015

Introduction To Temporal Tables In SQL Server 2016

Hi friends, today I will get you introduced with another new feature of SQL Server 2016 i.e. Temporal Tables. SQL …

Continue reading Read more

0 comments, 2,050 reads

Posted in Kapil Blogs on 20 July 2015

HASSUG BI Developer Presentation on 7/14/2015

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG).  This session resulted from feedback we received in the user group on differences between database developers and BI developers.  If you are interested in seeing the presentation content it is uploaded here: Read more

1 comments, 140 reads

Posted in Business Intelligence and Enterprise Architecture on 19 July 2015

See you at SQL Saturday Baton Rouge 2015!

SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQL Saturday 2015 event is produced by the Baton Rouge User Groups, and will be our sixth annual event on campus at LSU. We…

Read more

0 comments, 92 reads

Posted in SQL Tact on 19 July 2015

Merge statement- A simple way for DML TIP#105

When, I first saw this statement a Hindi proverb  come to my mind which is “1 teer 2 nishane” . The meaning of this proverb means a single bow which hit two different aim in one shot.

So let me explain “Merge” statement in more detail. With the help of… Read more

0 comments, 245 reads

Posted in Rajat Jaiswal-337252 on 18 July 2015

Newer posts

Older posts