Additional Articles

How to Get SQL Server Dates and Times Horribly Wrong

by Additional Articles

SimpleTalk

Date Manipulation

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

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

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

Converting and Using Text Dates as SQL Server Dates

by Additional Articles

MSSQLTips.com

Date Manipulation

This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.

2015-05-28

7,705 reads

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

by Additional Articles

SimpleTalk

PERCENT_RANK

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.

2015-05-27

7,757 reads

Optimizing Batch Process in SQL Server

by Additional Articles

SimpleTalk

batch processing

SQL Server batch processes are usually run from SQL Agent in the background. Often, the responsibility for creating these tasks belongs entirely to the developer. Dennes Torres demonstrates that DBAs can advise and assist with this type of batch job to help reduce their impact on the working system.

2015-05-25

7,564 reads

All authors

Additional Articles

How to Get SQL Server Dates and Times Horribly Wrong

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

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

A Plethora of PowerShell Pitfalls: Part 2

Converting and Using Text Dates as SQL Server Dates

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Optimizing Batch Process in SQL Server

Blogs

How Fabric Mirroring Transformed with SQL Server 2025

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility