Blogs

23 September 2016

PSYaml: PowerShell does YAML

PSYaml is a simple PowerShell module that I’ve written that allows you to serialize PowerShell objects to “YAML Ain’t Markup Language” (YAML) documents and deserialize YAML documents to PowerShell objects. It uses Antoine Aubry’s excellent YamlDotNet library To start, you can simply load the PowerShell file and the manifest from its home on GitHub PSYaml … Read more
21 September 2016

On Being Economical with the Truth

A while back, I attended a presentation about a suite of software that allowed IT managers to track in some detail the progress of a development project, via static code analysis, a range of source control metrics and other magic. Bathed in these insights, management could instantly track the detail of what was going on … Read more
20 September 2016

SQL Server Geeks Annual Conference

A couple of weeks ago I was privileged to be able to travel out to Bengaluru in India to attend SQL Server Geeks Annual Summit. It was my first time at the event and my first time in India. While the food was wonderful and the people were great, please allow me to focus on … Read more
16 September 2016

Careful With Trustworthy Setting

Trustworthy database setting is an easy solution for some problems in the server, especially cross database access. However, this setting has also a security problem in some scenarios. The scenario that has a security break is the following: One or more databases are owned by a user with ‘sysadmin’ rights. If the databases were created … Read more
08 September 2016

JSON and the Arguments

Now that we’re getting better support for storing JSON (JavaScript Object Notation) in databases, what is it really giving us? Whatever else, the technique of “stuffing data into a JSON blob and adding an index” doesn’t always absolve us from the task of carefully designing and normalizing our database schema. There are many advantages, I’ll … Read more
31 August 2016

The SQL of Textonyms

The task of finding textonyms in SQL involves importing a list of common words and doing transformations on every word to convert it into what you'd need to type into the numeric keypad of your mobile phone to get that word. It's not that hard to do, but what is the quickest and most efficient way of doing it? Phil Factor investigates.… Read more
31 August 2016

Creating schemas without DBO permission

One result of having the correct care with the access permissions in our databases is the need to avoid the DBO permission even to the users responsible for the database model. Using the database roles such as ddl_admin or even in more grainy ways it’s easy to achieve this goal. However, it’s more complex when … Read more
30 August 2016

Why is Uninstalling SQL Server Such a Pain?

A developer friend of mine recently, upon the briefest mention of SQL Server, descended unexpectedly into a rant about the pain of getting rid of the blasted thing. I was somewhat taken aback. “Surely”, I protested, “the uninstall button is easy enough to find?” He shot me a pitying look; apparently it’s not as straightforward … Read more
29 July 2016

Ten Years Later

Simple Talk has just celebrated its tenth birthday, has changed its platform, and has been given a make-over. The original site was designed for a small select readership, but we now get a million page-views a month. Security, page-speed, manageability, readability and convenience have all played their part in in directing what we did, but what do you think?… Read more
13 July 2016

Azure SQL Data Warehouse Lives!

Frequently when a new piece of tech that I’m excited about is launched, total nerd that I am, I’ll start quoting Colin Clive in, still the best, James Wale’s Frankenstein. It’s ALIVE! ALIVE! Well, time to get excited. On Monday, July 11, Azure SQL Data Warehouse moves from being in preview on Azure to a … Read more
30 June 2016

Invoke-SqlCmd Just Got Better!

If you’ve read even just a few of my articles on Simple-Talk you know that I’m a big fan of PowerShell + SQL Server.  Over the years I have written a lot about how to collect data from your SQL Servers and store it somewhere, maybe in a database, maybe in a word document.  Well … Read more
30 June 2016

Data Security: Time to be Grown-Up

How do you quickly clear a room-full of application developers, short of shouting ‘fire’ and setting off a smoke-bomb? The answer, of course, is to stand up in front of them and announce that you are giving a talk about database access-control and security. Once, at a conference, I sat through a brilliant talk on … Read more
15 June 2016

Measure of a DBA

Marketing people are often surprised when a new version of SQL Server doesn’t quite generate the atmosphere of excited anticipation that they expected. After all, people seem to get themselves in a state of frenzy when a new iPhone is introduced, and suddenly their present phone looks like a museum item. The urge to upgrade … Read more
07 June 2016

IE vs. Chrome for Debugging Ajax Web Service Calls

I was recently attempting to get Cross Origin Resources Sharing (CORS) working with some of our web services so we can more easily achieve cross-domain calls in our product lines.  Having never done any work with CORS before, I found a tutorial and started configuring the project for CORS support.  Since I wasn’t really concerned … Read more
06 June 2016

Unmasking the Dynamic Data Masking

/* Revised 27th June   Dynamic data masking is a great product and solves some niche problems that come if you need to do certain testing with live data at the application level. You should, however, beware of using it as a database-level security device. I haven't yet used it in testing because I don't … Read more

Join Simple Talk

Join over 200,000 Microsoft professionals, and get full, free access to technical articles, our twice-monthly Simple Talk newsletter, and free SQL tools.

Sign up