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

Latest Blog Posts

Excel as a Database Professional

People ask me all the time how to become a DBA.  This is a topic that so many colleagues of mine write about, and talk about in their professional development tracks.  The more important question is once you “are” in the role of DBA, what to do next? Read more

0 comments, 508 reads

Posted in Pearl Knows on 24 September 2015

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in comparison with Standard Edition. One of these improvements is Advanced Scanning, which allows multiple scans to share one physical read from… Read more

0 comments, 162 reads

Posted in Forrards Group Database Blog on 24 September 2015

Database Mirroring Isn’t Going Anywhere

AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in many cases, the good old Database Mirroring is just good enough (and in some cases, better):

Database Mirroring can work in Standard Edition

Database Mirroring is supported in both… Read more

5 comments, 614 reads

Posted in Matan Yungman on 24 September 2015

Dynamic SQL & Quotename

Not quite fineprint, but sure feels like it!

Quotename can be a pretty cool function to simplify your dynamic sql, as it can ease some of the escaping of strings.

However, I normally use it for table/column names, and so hadn’t ran into a “gotcha” of this function until today. Read more

0 comments, 120 reads

Posted in SQL Barbarian on 23 September 2015

Deployment Contributor KeepTableColumns Filter

To help with this scenario (it is pretty specific):

You have a table that has columns that you do not know about when you create the dacpac, possibly you have a customer who modifies your schema after you deploy. If you deploy your dacpac those columns will be dropped which…

Read more

0 comments, 225 reads

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

Freecon – Oct 27 in Seattle

Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training, FREECON if you will, in Seattle as a prelude to the PASS Summit of 2015. You can read all about that here, with registration being here.

While I… Read more

0 comments, 196 reads

Posted in SQL RNNR on 23 September 2015

Inside an SSDT Deployment Contributor

In my deployment filter I have been asked a couple of times to allow columns that exist on a table that do not exist in a dacpac to be ignored so that they are deleted. The typical scenario is that a vendor supplies a database and then customers can add…

Read more

0 comments, 131 reads

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

SSC Editorial: The Counter Offer – Part 1/Part 2

Counter offers (and the related discussions) are an emotional topic. The comments on two of my editorials for SQLServerCentral (The Counter Offer – Part 1 and The Counter Offer – Part 2) show that.  The takeaway for me is that we are still torn about being loyal employees… Read more

0 comments, 153 reads

Posted in SQLAndy on 23 September 2015

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, 582 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

13 comments, 3,327 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, 130 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,315 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, 125 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, 156 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, 124 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, 314 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, 162 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, 251 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, 123 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, 141 reads

Posted in SQL RNNR on 22 September 2015

Newer posts

Older posts