Blogs Tony Davis in Blogs Bridging the DevOps Divide What’s the main obstacle to implementing a DevOps approach in your organization? In a recent “State of DevOps” survey conducted... 05 January 2017 3 min read
Blogs Dennes Torres in Blogs How to allow nulls in unique fields An interesting workaround using unique fields Unique fields in SQL Server are created using unique constraints or unique indexes, furthermore,... 27 December 2016 2 min read
Blogs Simple Talk Editorial Team in Blogs Trouble with TLAs? Our Agony Aunt Advises Dear Marjorie, I try my best to keep up with the latest technology. I even read “IT Trends Monthly” religiously,... 16 December 2016 3 min read
Blogs Tony Davis in Blogs The Dangers of TechnoMarketingBabble Everyone’s encouraged to be a content producer these days. It’s not marketing, it’s content! Sometimes the tell-tale signs are obvious.... 01 December 2016 3 min read
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
