But, but, but, my data is clean!
Gail Shaw on the challenges of trying to extract meaningful data from a database containing customers who have the name 'Dummy **DO NOT USE**''.
2014-06-23
329 reads
Articles
Introduction to SQL Server in Microsoft Azure
The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features. These limitations can be eliminated by taking advantage of the Microsoft Azure IaaS capabilities and installing a SQL Server instance in an Azure-hosted VM.
2014-06-23
5,979 reads
Unwelcome posts on our forums
As you may have noticed, we have been suffering recently from increased spam posts on the forums. This is something we're currently working to resolve.
2014-06-20
3,038 reads
My month with Release!
Alex and his team are developing a game about software and some of the people who make it. He looks at how games affected his office culture, what he’s learned about designing games to do more than just be fun, and how his team are hoping to share their passion with the developer community.
2014-06-20
3,352 reads
Using DBCC DROPCLEANBUFFERS When Testing Performance
Over the years I've had many discussions with other SQL Server Database Administrators as to whether or not you should have the database buffer pool loaded with data pages or empty when testing queries for performance. This tip will take a look at the effects on query performance for both cases by using the DBCC DROPCLEANBUFFERS statement to empty the buffer pool.
2014-06-20
8,763 reads
Go to a User Group
Are you in a rut? Feeling a bit bored at work writing the same ole code? Or perhaps you need a job and only wish you could be bored "at work"!
2014-06-19
61 reads
PowerShell One-Liners: Accessing, Handling and Writing Data
In the grand finale to Michael Sorens' series of PowerShell one-liners, we come to the handling of data, reading it in and writing it out, whether by files; input/output streams or a database. It shows how it can be done in a variety of formats including CSV, JSON, and XML.
2014-06-19
5,763 reads
Cloud Storage Security: Are You Doing Your Part?
If the level cloud storage encryption are so high, then why is the cloud security industry experiencing such distrust?
2014-06-18
91 reads
Automated testing in Microsoft Azure
Matthew Flatt was trying to measure the performance of a tool interacting with Microsoft Azure, and had trouble getting a consistent test. His solution? Run the tests on VMs in Azure, housed in the same data center as the blob storage.
2014-06-18
2,717 reads
Server Role Membership Validation
Need to know how to verify if a login has server-level access to your SQL Server instance?
2014-06-17
2,766 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers