Articles

One of the times that you need things to go right is when you are doing analysis and reporting. This is generally based on time and date. A sure-fire way of getting managers upset is to get the figures horribly wrong by messing up the way that you handle datetime values in SQL Server. In the interests of peace, harmony and a long career in BI, Robert Sheldon outlines some of the worst mistakes you can make when using SQL Server dates.

2015-06-08

7,158 reads

Demystifying the use of CASE in an ORDER BY statement

by Chuck Hoffman

SQLServerCentral.com

CASE

Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(140)

You rated this post out of 5. Change rating

2015-06-05 (first published: 2012-04-26)

26,563 reads

Discuss

System Stored Procedures for SQL Azure Linked Servers

by Additional Articles

MSSQLTips.com

Windows Azure SQL Database

Microsoft released the preview version of Azure SQL Database V12 in December of 2014. As a database administrator, you might wonder about the schema and security of these new data marts. Microsoft has supplied system stored procedures for the database developer to query the Linked Servers for this type of meta data, as John Miner explains.

2015-06-05

2,288 reads

The Importance of Database Indexing

by Additional Articles

CodeProject.com

Indexing

In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.

2015-06-04

7,210 reads

Query Folding in Power Query to Improve Performance

by Additional Articles

MSSQLTips.com

Power Query

In this tip Koen Verbeeck discusses query folding, how you can take advantage from it and how to make sure query folding takes place.

2015-06-03

3,661 reads

Cybercrime - the Dark Edges of the Internet

by Additional Articles

SimpleTalk

cybercrime

Criminal activity is a growing menace on the internet: This inevitably means more diligence is required by legitimate users in the face of an increasingly sophisticated criminal threat. Robert Sheldon describes some of the emerging threats and risks.

2015-06-02

4,544 reads

Take our SQLServerCentral Users Survey

by Press Release

SQLServerCentral.com

survey

Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-06-02 (first published: 2015-05-26)

13,214 reads

The MidnightDBAs release Minion Backup

by Press Release

SQLServerCentral.com

minionware

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup. We created Minion Backup (or MB, for short) to be the most flexible, feature-rich backup solution possible.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2015-06-01

1,609 reads

Discuss

Converting Comma Separated Value to Rows and Vice Versa in SQL Server

by Additional Articles

Database Journal

Convert row to column

Often while reporting you will encounter a situation where you will have comma separated values in a single column but you want to report them in rows. In other cases you might have values in multiple rows and want them to be a single value separated by comma or some other character. Arshad Ali demonstrates how to write queries in SQL Server to handle these scenarios quickly.

2015-06-01

5,990 reads

A Plethora of PowerShell Pitfalls: Part 2

by Additional Articles

SimpleTalk

PowerShell

There are some pitfalls in PowerShell for the unwary. Many people who are learning PowerShell come across quirks that can cause frustration. Michael Sorens continues his series, warning abut four of the most common PowerShell pitfalls and explains how to avoid them.

2015-05-29

7,299 reads

Articles

How to Get SQL Server Dates and Times Horribly Wrong

Demystifying the use of CASE in an ORDER BY statement

System Stored Procedures for SQL Azure Linked Servers

The Importance of Database Indexing

Query Folding in Power Query to Improve Performance

Cybercrime - the Dark Edges of the Internet

Take our SQLServerCentral Users Survey

The MidnightDBAs release Minion Backup

Converting Comma Separated Value to Rows and Vice Versa in SQL Server

A Plethora of PowerShell Pitfalls: Part 2

Blogs

Git forked

Setting FK Constraints in Data Modeler

Webinar: Navigating the Database Landscape in 2026

Forums

SSMS 22 Latest Update Crashing

Transactional Replication setup issue

The Power of Data and Privacy

Question of the Day

What's the Date?