DBAs and the ITIL Framework, Part II: Asset Management
See how the ITIL Framework’s Asset Management standards make the DBA’s job easier. Use the CMDB and DML to keep your data assets under tight control.
FAQs: Encryption With ExpressRoute; Understanding Which Capabilities Are Supported With ASR; Handling Files Downloaded From The Internet
Three times a week, John Savill tackles your most pressing IT questions.
CIA’s On-Prem Amazon Cloud Now Available to Other Agencies
Intelligence Community agencies with sub-Top Secret data secrecy classifications can now use the « air-gapped » cloud.
Researchers Discover Pentagon Intelligence Data on Open AWS S3 Buckets
Third-party government contractor left U.S. surveillance data on open AWS S3 buckets, researchers say
SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group
As a part of my consulting job, I do work with clients who wanted to deploy AlwaysOn availability group. Sometimes there are some simple errors which are encountered, but new DBAs are not aware of such things. In this blog we would talk about one of su …
Summer 2018 classes in London open for registration
Due to popular demand, we’re coming back to London in 2018 and I’ve just released our classes for registration! All classes have discounts for registering before the end of 2017! (details on the individual class web pages…) …
Security Sense: You Can Outsource the Work but Never the Risk
There have been many recent cases where organizations have suffered serious data breaches at the hands of third parties.
[Video] Office Hours 2017/11/15 (With Transcriptions)
This week Brent, Erik, Richie, and Tara discuss Docker, writing to different servers in different locations, SAN Replication, reducing the size of a database, patching Availability Groups, getting rid of failover cluster instances, long-term backup sto …
Updated Stack Overflow Database Dump Importer v1.4
The nice folks at Stack Overflow publish their entire data set (data included) in XML format. It’s tons of fun for demos, but you need a way to get it into a relational database. The Stack Overflow Data Dump Importer (SODDI) makes this …
The real origins of the Agile Manifesto
Many people think the Agile Manifesto was born in in February 2001, when 17 people met at the Snowbird ski resort in Utah. But there’s a problem, a big problem – in fact, one about the size of the USA’s first ever jet fighter. In this blog …
Importing Historical Stock Prices from Yahoo Finance into SQL Server
Rick Dobson demonstrate a clean end-to-end solution for importing historical stock ticker prices from Yahoo Finance into a SQL Server table using Python.
Automatic Plan Correction
SQL Server 2017 lets you solve parameter sniffing problems – Automatically!
SQL SERVER – Add Node Error – Rule “SQL Server Database Services Feature State” Failed
While deploying SQL Server 2016 cluster in my lab I ran into this problem when I was trying to add a second node to the SQL cluster. Let us learn about Add Node Error and how to solve it in this blog post. Rule “SQL Server Database Services featu …
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
Question: How to Assign Multiple Variables in a Single T-SQL Query? Answer: I do remember answering this question many years ago, when it was newly introduced in SQL Server. It has been so long that I have forgotten that in which version of SQL Se …
How to Plan a Migration to AWS: The Cox Automotive Story
Sponsored by: AWS – Tuesday, 12/5/17 at 11 am PST/2 pm EST