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

Latest Blog Posts

Top 3 Questions Before Submitting to a SQL Saturday

Hello Dear Reader!  We are coming up upon the 9th SQL Saturday for Orlando.  Orlando is where SQL Saturday began, and the home to some pretty amazing speakers.

We, the SQL Saturday Orlando Team, are hard at work getting ready for the event.  Our Call for Speakers ends…

Read more

5 comments, 116 reads

Posted in SQLBalls on 25 June 2015

24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts

Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.

It was a lot of fun taking part in such a special event.

The slide deck and scripts I used in the session can be downloaded here.

The post 24 Hours of PASS:… Read more

0 comments, 146 reads

Posted in Matan Yungman on 25 June 2015

ExpressProfiler: say "Hi!" to new developer!

I glad to introduce new member of Express Profiler team - Chris Moore!
He has many ideas and eager to implement them.
Welcome onboard, Chris!

Read more

0 comments, 132 reads

Posted in SQL Code Guard on 25 June 2015

SQL Azure has T-SQL Jobs - Well Almost

SQL Azure has T-SQL Jobs - Well Almost
JUNE 25, 2015

One thing that has been lacking in Azure SQL Database is the ability to write database jobs in Transact-SQL. Recently, Microsoft has introduced T-SQL database jobs this functionality in Elastic Database Jobs. This article will talk about the…

Read more

0 comments, 907 reads

Posted in Pie in the Sky on 25 June 2015

SQL Server Infernals – Circle 2: Generalizers

Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies are a good way of reusing code, hitting the specialized classes only when a special implementation is needed.

In the database world, the concept doesn’t play exactly well.

What they…

Read more

1 comments, 156 reads

Posted in SpaghettiDBA on 24 June 2015

oPASS June 2015: Using BI Power tools to visualize your SQL Infrastructure with Rodney Landrum

The next oPASS meeting is tomorrow night (June 25, 2015):

DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can…

Read more

0 comments, 15 reads

Posted in SQLAndy on 24 June 2015

Working at Microsoft – A Year in Reflection

Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing experience with many companies during my tenure at my last employer (Click here for article).  I realized it is now time to talk about my journey to Microsoft. It has…

Read more

1 comments, 258 reads

Posted in - Ayman El-Ghazali on 24 June 2015

Seeking Full Day Seminars For The Friday Before SQLSaturday Orlando 2015

We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015. What are we looking for?

  • An interesting topic. I know that’s vague, so let’s say we want a topic that will be of interest to 15+ people willing to…

Read more

0 comments, 14 reads

Posted in SQLAndy on 24 June 2015

Why does sqlpackage.exe not compare after the pre deployment script has run?

It isn't a Pre compare script

When you use SSDT to deploy your dacpac, a pre deployment script lets you run some T-SQL scripts before the script which brings your database up to date with your dacpac.

The important thing to note is that the process is:

  • sqlpackage compares the…

Read more

0 comments, 102 reads

Posted in Ed Elliott's Sql Developer Blog on 24 June 2015

Adding Extended Properties to a Table

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I had the need recently to get put an extended property on a table in a database. I could easily have done this in SSMS, and have used… Read more

1 comments, 1,237 reads

Posted in The Voice of the DBA on 24 June 2015

Some simple examples of querying xml with sql

XML is a beast if you've never tackled it. Here are some simple examples of what I discovered as I experimented and walked through obtaining values out of a XML column.

Read more

0 comments, 2,093 reads

Posted in SQL Barbarian on 24 June 2015

Use 100% Fill Factor on Insert Only Tables

SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page splits. If you picture library shelves, it’s like leaving space for a couple new books on each shelf. It’s a trade-off though, putting in that space may reduce page splits… Read more

0 comments, 13 reads

Posted in SQLAndy on 24 June 2015

#SQLVacation Postcard from Evansville, Indiana

Our long #SQLVacation is nearly at an end because our stop in Evansville, IN is our last roadtrip location for the family and the penultimate (i.e., second to last) technical session of the journey. It’s a bittersweet, fersher.

Evansville is such a beautiful place that it was name La Belle… Read more

1 comments, 116 reads

Posted in Kevin E. Kline on 24 June 2015

SQL Cruise Mediterranean+

This is a post that is looooong overdue. I have intended to write some of this at least since the first SQL Cruise I attended back in 2013 (in the Caribbean). Now with three Cruises under the belt and plenty of awesome experiences, it is high time to follow through… Read more

2 comments, 114 reads

Posted in SQL RNNR on 24 June 2015

Which user function do I use?

Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you have created these type of columns before you have probably put a default on each. InsertDate is pretty easy, probably something like GETDATE() or GETUTCDATE(). But what do you… Read more

0 comments, 1,366 reads

Posted in SQLStudies on 24 June 2015

SQL Code Guard - Developer build: just as planned

Well, not exactly just as planned, but at last!
Few minor fixes
[*] fixed unparsed with CONTAINS condition
[*] fixed xtra "ST010 Use alias for all table sources" for UPDATE/DELETE statements with single FROM clause item
[*] fixed xtra MI003 "Unqualified column name" on DATENAME(MONTH, GETDATE())
You can download Developer…

Read more

0 comments, 122 reads

Posted in SQL Code Guard on 24 June 2015

Leveraging SQL Server Database Schema

Leveraging SQL Server Database Schema

Data warehouses typically pull data from various sources and combine the data into a common repository.  Keeping up with the source systems and what data is being pulled from each system can be challenging.  One method that can be used to easily identify the source…

Read more

1 comments, 117 reads

Posted in Business Intelligence and Enterprise Architecture on 24 June 2015

Exams 70-457 & 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012

This past week I finally completed the 70-458 exam to upgrade my certification to MSCA: SQL Server 2012. I never thought it would take me over a year to pass two upgrade exams, but sometimes life just gets in the way. I will say this is probably the hardest SQL…

Read more

0 comments, 124 reads

Posted in Everyday SQL on 24 June 2015

MSSQLTips / Tegile Systems Webinar Wrap up

Thank you all for attending my MSSQLTips webinar today with Sumeet Bansal from Tegile Systems! In the presentation, I made reference to a disk stall collector that you can use to help collect and store database file-level latency statistics into a database for future reference, as well as an… Read more

0 comments, 222 reads

Posted in Technobabble by Klee from @kleegeek on 23 June 2015

Our Meeting and The Day Out

Last week, Redgate Software had a large company meeting and our annual Day Out, with myself and a few dozen of our US employees in the UK for meetings and the event. It was fun, and a good time. I haven’t been to a company meeting live in 6 or… Read more

0 comments, 153 reads

Posted in The Voice of the DBA on 23 June 2015

Newer posts

Older posts