A community of more than 1,600,000 database professionals and growing

Featured Script

T-SQL implementation of FizzBuzz

The Voice of the DBA

Byte Me: Specific Wishlist

Bob Lang from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

Track schema changes for free

DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool.

SQL Monitor - Always have the answers to SQL performance issues

SQL Monitor keeps an eye on your SQL Servers 24/7, so you don't have to. It helps you proactively monitor the performance of your SQL Servers, saving you time, and makes sure you always have the answers to tough performance problems. Find out more.

How can you help your team write better, shareable SQL faster?

Find out by discovering 15 Super SQL Tips from Microsoft MVPs and other SQL Server experts. Using SQL Prompt to write, refactor, and share SQL, they show how it strips away the repetition of coding and standardizes it everywhere. View the tips and download a free trial.

Featured Contents

Common questions about Azure SQL Data Warehouse

Daniel Calbimonte from SQLServerCentral.com

This article compiles some common questions and answers about Azure SQL Data Warehouse. More »

Free eBook: Defensive Database Programming

Press Release from Redgate

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. More »

Importing Excel Data into Power BI Desktop

Additional Articles from SimpleTalk

In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made more generally available for sharing and further analysis. As well as the data, we'd probably need the other analysis components such as the Power Pivot tables, Power View visualizations, Power Query queries. It is all possible, and Robert Sheldon demonstrates how. More »

From the SQLServerCentral Blogs - Analysis Services and Power BI: Time-travel, Space-warping and Teleportation

pturley from SQLServerCentral Blogs

As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ... More »

Question of the Day

Today's Question (by Steve Jones):

It's the last week of 2016, so I thought we'd have some fun with questions. These are minor trivia items, so have fun guessing.

How many founders did SQLServerCentral have?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 7 points in this category: humor.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

It's the last week of 2016, so I thought we'd have some fun with questions. These are minor trivia items, so have fun guessing.

In 2016, Grant Fritchey bought a new vehicle for himself. What make and model was it?

Answer: A Jeep Wrangler

Explanation:

Grant purchased a Jeep Wrangler this year.

Ref: https://twitter.com/GFritchey/statuses/761543374641958912

» Discuss this question and answer on the forums

Featured Script

T-SQL implementation of FizzBuzz

Eric Russell from SQLServerCentral.com

FizzBuzz has long been used as an interview screening device for computer programmers. The task is as follows: Print the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both three and five print “FizzBuzz”.

For what it's worth, here I present my own T-SQL implementation of FizzBuzz consisting of a single SELECT statement.

Feel free to reply with your own variation in the discussion forum for this post.

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Administration

An evaluation copy of SQL 2016? - Not too long ago I downloaded SQL Server 2016. I was certain that I had downloaded the Developer Edition, which...

SQL server service pack,hotfix applied dates - Hello, Found Powershell script in below blog to list the last install date and time for windows updates on servers. https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca Is there...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Need help with SQL query - Hi All, I'm pretty new to this and am in need of some help writing a query. I'll try to explain. I...

SQL Server 2014 : Administration - SQL Server 2014

Table Replication. - I have a mirror in place. since i don't have enterprise edition i need to do maintenance(index rebuild offline, Gather...

SQL Server 2014 : Development - SQL Server 2014

Exclude the data starts with ING - Hello, how to write a query - to exclude the field that starts with ING select * form table where ID NOT LIKE...

Overlapping datetime ranges. - Overlap in ranges. I have a set of data,rows which a start_time and a end_time. Each row should get a New_starttime, so...

SQL Server 2012 : SQL 2012 - General

Is there a matured solution to ETL excel data? - Merry Christmas and happy new year! From time to time my work needs to deal with lots of excel sheets from...

SQL database recovery from corrupt database file! - Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which...

SQL Server 2012 : SQL Server 2012 - T-SQL

Issue with column parsing - Hello, I have data from two different sources - Source1 and Source2 - we have a dtsx package where it loads data...

Compare two tables and insert the differences - Hello, I have two tables -- Table A in Server A of Database A -- Table B in Server B of Database B My...

Using Large Integer Or GUID Vs Using Small Integers For Primary Key - Hi all, Would using UserID column (GUID) or BankAccount column (9 digit integer) as the primary key column be less...

Plan Guides -- depend on "as clause" alias? - I'm trying to use plan guides to help some bad ORM queries ( hinting option(recompile ). Now I see that nearly identical...

How can I query it fast ? - I have a few million records in a csv file. This has only one field which is a driver md5 ( eg....

RAISERROR - Stored Proc wrapped in sqlAgent job - hi, This is a classic scenario of an SP wrapped in a sqlAgent job and despite SP failing to do its...

Bitwise & NULL - I have a large number of yes/no columns for a table. Rather than creating a bit field for each, I'd...

Parsing paired relationships. - Hmmm... OK, I can do this but only with some really expensive RBAR table operations, the script I've written takes...

Update had to be done in two steps, Why? - Originally I had this query: Original value for starttime is 1800001 (Clarion time figures based upon 1/100 of a sec since...

SQL Server 2008 : SQL Server 2008 - General

xp_cmdshell heartaches - I have a sub folder on my 2008 sql server listing backup files. All I want to do is store...

SSIS - Export multiple SQL queries to one excel spreadsheet - Hi All, I am using SSIS and I am trying to export 3 separate SQL queries to one excel spreadsheet. These...

Data Warehousing : Strategies and Ideas

Incremental refresh and error recovery question - I am refreshing a warehouse table nightly. The refresh is designed so that only when all the tables are successfully...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.