Blogs Tony Davis in Blogs Virtue in the Virtual Are we now seeing just a frisson of excitement amongst database professionals at the potential of virtualization, and containerization technologies?... 21 November 2016 3 min read
Blogs Tony Davis in Blogs When Stored Procedures Go Bad It is far easier to work out what is wrong with a slow-running SQL query than one that shows erratic... 04 November 2016 3 min read
Blogs William Brewer in Blogs Skilling and De-skilling Not long ago, I was having to do a fairly simple DBA task onsite. It involved database provisioning by copying... 20 October 2016 3 min read
Blogs Tony Davis in Blogs Removing the Clutter from Graphs You can quickly get an audience to see patterns and trends in data if you present that data graphically. Data... 04 October 2016 3 min read
Blogs Phil Factor in Blogs 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... 23 September 2016 17 min read
Blogs Phil Factor in Blogs 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... 21 September 2016 3 min read
Blogs Grant Fritchey in Blogs 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... 20 September 2016 5 min read
Blogs Dennes Torres in Blogs Careful With Trustworthy Setting Trustworthy database setting is an easy solution for some problems in the server, especially cross database access. However, this setting... 16 September 2016 2 min read
Blogs Tony Davis in Blogs 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?... 08 September 2016 3 min read
Blogs Phil Factor in Blogs The SQL of Textonyms The task of finding textonyms in SQL involves importing a list of common words and doing transformations on every word... 31 August 2016 14 min read
Blogs Dennes Torres in Blogs 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... 31 August 2016 2 min read
Blogs Tony Davis in Blogs 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... 30 August 2016 3 min read
Blogs Tony Davis in Blogs Software Animism The tendency to attribute malice to inanimate objects is deeply entrenched in the human psyche. In a famous account from... 11 August 2016 2 min read
Blogs Phil Factor in Blogs Creating PowerShell Stacks and Expression Evaluators To demonstrate that dynamic modules in PowerShell can be used to easily create objects with methods and properties, Phil Factor... 02 August 2016 10 min read
Grant Fritchey An Introduction to In-Memory OLTP Database Objects In-memory OLTP was introduced in SQL Server 2014, but greatly improved in SQL Server 2016. If you have a heavily-used... 01 August 2016 4 min read
Blogs Simple Talk Editorial Team in Blogs Ten Years Later Simple Talk has just celebrated its tenth birthday, has changed its platform, and has been given a make-over. The original... 29 July 2016 2 min read
Simple Talk Editorial Team Caption Competition 58 – Royal Tweetment Hallucinating at the coronation, or just elaborate costumes? Tell us what’s going on here and our favourite answer will win... 30 June 2016 1 min read
Laerte Junior 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... 30 June 2016 3 min read
Phil Factor 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... 30 June 2016 3 min read
Simple Talk Editorial Team Caption Competition 57 – Bicircling What’s going on in this week’s scene? Leave a caption in the comments before June 30th, and the response we... 16 June 2016 1 min read