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

Latest Blog Posts

SQL Server’s TIMESTAMP Is Not What You May Think It Is. - WaterOx Consulting

TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL...

The post SQL Server’s TIMESTAMP Is Not What You May Think It Is. appeared first on WaterOx Consulting.

Read more

1 comments, 592 reads

Posted in WaterOx SQL on 23 September 2015

Pratical Use of a SQL Server Database Snapshot

I was doing a database code deployment the other night and the first step in the release plan was “Take a full database backup in case we have to roll back the deployment”. The database in question was about 100 GB in size, so not huge, but not small either.… Read more

10 comments, 3,381 reads

Posted in on 23 September 2015

I’m Speaking! SQL Saturday #431 – Spartanburg

As I’ve mentioned before, living in Louisville offers up great opportunities to various events within the SQL Community.  This weekend I’ll be traveling down to Spartanburg, South Carolina to speak at SQL Saturday #431.  I am always honored to be chosen to speak and this time isn’t any different.  While… Read more

1 comments, 132 reads

Posted in John Morehouse | on 23 September 2015

Predicate Order is Critical

I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining a reasonably performing event monitoring system.

The proper order of a predicate… Read more

0 comments, 2,348 reads

Posted in SQL RNNR on 23 September 2015

“sql_handle” is not a recognized table hints option.

I’ve you’ve run a query similar to the following:

FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);

And gotten an error similar to:

Msg 321, Level 15, State 1, Line 9
“sql_handle” is not a recognized table hints option. If it is intended as a parameter to a table-valued function or…
Read more

0 comments, 126 reads

Posted in SQLStudies on 23 September 2015

Webinar: Kicking the Tires on SSIS 2016

The next version of SSIS is on the horizon. Are you ready?

In next Tuesday’s webinar, I’ll be reviewing and demonstrating the new features of SQL Server Integration Services. Microsoft recently released the CTP bits for SQL Server and SQL Server Data Tools, both of which show several useful… Read more

0 comments, 158 reads

Posted in Tim Mitchell on 23 September 2015

Setting up a new CI server to build SSDT projects

I am going to ignore the fact that people don't want to install visual studio on a build server, in the future there will likely be a way to install just the required components rather than everything. Today, the way I see it is that I develop in Visual Studio,…

Read more

0 comments, 125 reads

Posted in Ed Elliott's Sql Developer Blog on 23 September 2015

Power BI Custom Visuals Contest Round-up

It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been running for about two weeks and wraps up on October 1. The first people's choice award winner is Daniele Perilli from Rome who submitted a nice horizontal bullet chart. The…

Read more

3 comments, 319 reads

Posted in SQL Server BI Blog on 22 September 2015

Costumes at the PASS Summit

tl,dr; We’re raising money for Doctors without Borders. Donate and a few of us will dress up at the Summit. You don’t have to attend the Summit to have some fun here.

Last year a bunch of us agreed to get silly to raise money. We ended up getting over… Read more

0 comments, 164 reads

Posted in The Voice of the DBA on 22 September 2015

Repairing a replication subscriber

It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes corrupt, is running CheckDB with repair allow data loss safe?

The theory is, since the subscriber is a copy of another database, allowing CheckDB to discard data in the process… Read more

0 comments, 253 reads

Posted in SQL In The Wild on 22 September 2015

Heading To PASS Summit 2015 – Now What?

You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the company would send you to PASS Summit 2015. A few days or weeks elapse and you get word that you were the chosen one from the company to attend… Read more

0 comments, 124 reads

Posted in The SQL Professor on 22 September 2015

Comparison Predicates and Event Data

In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of predicates. There are two objects that fall into the predicate category and then there are data comparison predicates (those that are not objects).

The two objects are pred_compare… Read more

0 comments, 142 reads

Posted in SQL RNNR on 22 September 2015

Finding Next Business Day in T-SQL

Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait, I’m being told that Production.TransactionHistory in AdventureWorks sample database matches this description. So let’s use that for this demonstration.

Here’s the simplified schema of that table.

CREATE TABLE [Production].[TransactionHistory]

Read more

3 comments, 549 reads

Posted in Sam Vanga on 22 September 2015

Most Read: My Top 5 SQL Server Articles and Blogs

There has been some really useful blogs and articles posted over the last week or so, this is my top 5 in no particular order

  • Interesting post here from looking at the statistics on the uptake of SQL Server 2014 and the reluctance of businesses to move from older…

Read more

0 comments, 135 reads

Posted in The SQL DBA in the UK on 22 September 2015

Encrypting Connections To SQL Server Using Certificates

Encrypting Connections To SQL Server Using Certificates

In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates. The audience for this document is a developer that needs to configure encrypted connections from applications to a database server.

Encrypting… Read more

0 comments, 278 reads

Posted in Anthony Nocentino's Blog on 22 September 2015

Populating My DBA Database for Power Bi with PowerShell – Databases

Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.

In this post I will show how to create the following report

Although you will find so many items of data… Read more

0 comments, 126 reads

Posted in SQL DBA With A Beard on 22 September 2015

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects (tables or indexes).

First let me remind you that some versions of SQL Server (Enterprise, Evaluation, Developer) allow you to perform… Read more

0 comments, 124 reads

Posted in Forrards Group Database Blog on 22 September 2015

DR drill - Part 2: Log Shipping

Welcome back to DR drill series!

In the last post (here), we have highlighted a number of ways to setup disaster recovery in SQL server, we will discuss the first one here - Log Shipping.

 Log shipping (LS for short) has been around for many years - since…

Read more

0 comments, 121 reads

Posted in Dennis's SQL Blog on 22 September 2015

Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)

Continuation from the previous 66 parts, the whole series can be found at Continuing from the last couple of blog posts on the improvements for the DataWarehouse scenario with Clustered Columnstore Indexes, I want to turn this time to…

Read more

0 comments, 139 reads

Posted in Niko's blog on 22 September 2015

No thrills about spills

Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a form of a histogram with at the most 200 steps, regardless of the number of rows in the column or index. A lot about statistics can be found in this… Read more

0 comments, 142 reads

Posted in SQLYSE with Pankaj Manek on 21 September 2015

Newer posts

Older posts