Additional Articles

Powershell day-to-day Admin tasks: WMI, CIM and PSWA

by Additional Articles

SimpleTalk

PowerShell

WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.

2015-06-15

4,326 reads

Managing Test Data as a Database CI Component - Part 2

by Additional Articles

SimpleTalk

Continuous Integration (CI)

Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.

2015-06-12

3,004 reads

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

by Additional Articles

SQLServerCentral

pivot

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2015-06-11

5,039 reads

Reusing T-SQL Code

by Additional Articles

SimpleTalk

T-SQL

Alex Kuznetsov, in an article taken from his book 'Defensive Database Programming with SQL Server', shows how DRY principles can be put in practice with constraints, stored procedures, triggers, UDFs and indexes.

2015-06-10

6,344 reads

Protecting Yourself from SQL Injection in SQL Server - Part 2

by Additional Articles

MSSQLTips.com

sql injection

Aaron Bertrand has some advice on how to protect yourself from SQL Injection, looking at some specific common scenarios.

2015-06-09

4,756 reads

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

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

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

All authors

Additional Articles

Powershell day-to-day Admin tasks: WMI, CIM and PSWA

Managing Test Data as a Database CI Component - Part 2

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Reusing T-SQL Code

Protecting Yourself from SQL Injection in SQL Server - Part 2

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

Blogs

A New Word: Gnossienne

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

Forums

How Can SQL Server Detect Application Errors When Developers Can’t?

Getting Database MaiL Profiles

Preserving Data

Question of the Day

Getting Database MaiL Profiles