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

Latest Blog Posts

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work…

Read more

0 comments, 27 reads

Posted in SQL Server BI Blog on 27 May 2015

Native Client Aliases don’t like Trailing Spaces

I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that it deserved a shout out to the community.

When you create an alias in the SQL Server Configuration Manager, make sure that the alias name contains no spaces,… Read more

0 comments, 34 reads

Posted in SpaghettiDBA on 26 May 2015

New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt from each with a link to the full article:   Getting Started with Datazen, Microsoft’s New Mobile Dashboard Platform (Part 1) Microsoft Datazen is a new tool from Microsoft built…

Read more

0 comments, 53 reads

Posted in SQL Server BI Blog on 26 May 2015

Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP

Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored procedure(With Execute as Owner), and was getting an error –

ERROR:

Could not obtain information about Windows NT group/user ‘Domain\UserName’, error code 0x5.

My first reaction was to… Read more

0 comments, 44 reads

Posted in SQLSailor.com on 26 May 2015

Migrating SQL Agent Jobs with Schedules using T-SQL

I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like. One thing I have not found readily is the ability to create jobs while maintaining the scheduling in place. For those who may not be aware, the easiest way to… Read more

0 comments, 60 reads

Posted in Jared Zagelbaum's Blog on 26 May 2015

Tuesday Morning SQL Break – May 26, 2015

It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information… Read more

0 comments, 49 reads

Posted in StrateSQL on 26 May 2015

Database Engine Tuning Advisor

I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that I included a chapter on it in my query tuning book (all updated for SQL Server 2014 by the way). Let me tell you why we need to pull… Read more

2 comments, 62 reads

Posted in The Scary DBA on 26 May 2015

SQL Agent Job Wrapper Part 3 – Handing the Errors in the Wrapper Script

This is the 3rd installment in a small series of blog posts on how to create a PowerShell wrapper for running SQL Server Agent Jobs. Here are the links to the 2 previous posts and I recommend reading them because all of the posts build on the previous one.

Creating… Read more

0 comments, 42 reads

Posted in cjsommer.com on 26 May 2015

Default database

What?
The default database is one of the options when creating a login in SQL Server. This is the initial database that the login will connect to when logging in. Unless of course you specify a different database in your connection string.
 
How?

-- Creating a login with a…

Read more

0 comments, 62 reads

Posted in SQLStudies on 26 May 2015

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite

Once you have created your database you can now start to manage and configure it.

There are six menus for a SQL Azure Database: -

  • Dashboard
  • Monitor
  • Scale
  • Configure
  • GEO-Replication
  • Auditing and Security
The Dashboard

The Dashboard gives an overview of the state of your Azure database.… Read more

0 comments, 52 reads

Posted in The SQL DBA in the UK on 26 May 2015

SQL Server 2016 features I’m interested in

Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can download the datasheet they’ve posted from here.

The features that have caught my attention are:-

  • Enhancements to In-Memory OLTP
  • The Query Data Store
  • Temporal Database
  • Stretch Database
  • Automatic failover…

Read more

0 comments, 60 reads

Posted in The DBA Who Came In From The Cold on 26 May 2015

Row Numbers and Running Totals in SSIS

During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL process itself, as well as for use in the destination database. Having an arbitrary, incrementing row number assigned to each row can help to determine the order in which the… Read more

0 comments, 55 reads

Posted in Tim Mitchell on 26 May 2015

Read the Transaction Logs in SQL Server

INTRODUCTION

In this tutorial we will know about, how to read a transaction log in SQL server and also we will learn all the reading methods of a transaction log. From this tutorial you will know why MS SQL permits you to read the transaction logs. As we know very…

Read more

0 comments, 91 reads

Posted in Zora's SQL Tips on 25 May 2015

Changing NULL to NOT NULL – Dealing with Data

I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple way. However I didn’t cover some of the cases where you have data in the column, or other restrictions that you might need to deal with. In this post, I… Read more

0 comments, 111 reads

Posted in The Voice of the DBA on 25 May 2015

Database Administration via CrowdSourcing

According to Wikipedia:

 Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group of people, and especially from an online community, rather than from traditional employees or suppliers.

Every DBA must have googled something to address his/her technical issue, and… Read more

0 comments, 84 reads

Posted in DBA Philosophy on 25 May 2015

Last Cumulative Update – 16 for SQL Server 2012 Service Pack 1 Is Now Available !

The 16th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 16 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 82 reads

Posted in MSSQLFUN on 25 May 2015

Cumulative Update – 6 for SQL Server 2012 Service Pack 2 Is Now Available !

The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 76 reads

Posted in MSSQLFUN on 25 May 2015

SQL Server 2014 Service Pack 1 (SP1) Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for download at the Microsoft Support site. SQL Server 2014 Service Pack 1 (SP1) contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

I suggest to… Read more

0 comments, 78 reads

Posted in MSSQLFUN on 25 May 2015

CDO Summit Toronto June 4th

I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th.  My session is on how to leverage predictive analytics to reduce customer churn.  I will be going over how I leveraged a decision tree model to create a customer risk score for active customers.… Read more

Older posts