Mo-SQL

by Andy Warren

Other

Blogs

If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.

TSQL Pivot Rotations using only REPLACE

by Additional Articles

SimpleTalk

T-SQL

Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOT, here is a way to do it using only REPLACE.

SQL Saturday #197 - Omaha

by Press Release

SQLServerCentral.com

SQL Saturday

Join us on April 6th in Omaha for SQL Saturday #197. SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.

The Command Shell

by Steve Jones

SQLServerCentral.com

Editorial

This Friday Steve Jones talks about xp_cmdshell and the security regarding its use. Do you have any holes that might exist if administrators are allowed to use this tool on their instances?

Using the SQL Server APP_NAME function to control stored procedure execution

by Additional Articles

MSSQLTips.com

Stored Procedures

In this tip we will look at one way to achieve control of stored procedures to ensure that reuse is for the intended purpose and changes do not break other applications that may be using this same code.

Halo 4 and Hadoop

by Steve Jones

SQLServerCentral.com

Editorial

A case study shows how the combination of Azure and Hadoop helped the Halo 4 team grow their successful franchise.

Re-throw Errors with Logging

by Harsha Majety

SQLServerCentral.com

Error Handling

This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.

Ad-Hoc XML File Querying

by Additional Articles

SQLServerCentral

When you need to shred just part of the data within a large XML file into a SQL Server table, the most efficient way is to just select what you need via XQuery or by using XPath, before shredding it into a table. But precisely how would you do that?

HASHBYTES: Is CHECKSUM really required?

by Nakul Vachhrajani

SQLServerCentral.com

T-SQL

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.

Steve Jones and Grant Fritchey at SQL Intersection

by Press Release

SQLServerCentral.com

SQL Intersection

SQL Server Central’s Steve Jones and Red Gate’s Grant Fritchey will be among a stellar line-up of speakers at SQL Intersection conference in Las Vegas on the 8th to the 11th of April.

Mo-SQL

TSQL Pivot Rotations using only REPLACE

SQL Saturday #197 - Omaha

The Command Shell

Using the SQL Server APP_NAME function to control stored procedure execution

Halo 4 and Hadoop

Re-throw Errors with Logging

Ad-Hoc XML File Querying

HASHBYTES: Is CHECKSUM really required?

Steve Jones and Grant Fritchey at SQL Intersection

Blogs

Track SQL Server Configuration Changes Using the Error Log

Data Engineering Books Worth Having on Your Shelf (or your tablet)

SSMS Evaluation – future ready

Forums

Alamat kontak resmi BCA KCU BOROBUDUR Telp:0817866887

SQL Server Showing Out of Space But Plenty of Drive Space

Creating a JSON Document IV

Question of the Day

Creating a JSON Document IV