2017 Brought More Open Standards for DevOps
The trend towards open standards will not only make life easier for DevOps, they will cut IT costs as well.
Next Christmas, How About Some Cybersecurity?
An ITPro Today writer says she doesn’t need anything next Christmas, but it would be nice if she can hold on to what she already has.
Public Cloud Vendors Found Unlikely Partners in 2017
Public cloud vendors like AWS and Google partnered with data center juggernauts in 2017 to bring enterprises to the cloud.
Microsoft in 2017: Quantum Computing Led the Way
Starting with Microsoft Quantum Computing, then following with Artificial Intelligence and Machine Learning, the company continued to grow their ability to provide customers with the right data at the right time to increase productivity across all aspe …
Cybersecurity Strategy: Top Security Resolutions for 2018
As the new year approaches, several IT analysts give their top cybersecurity strategy tips and key tasks to target to protect your company’s IT assets.
Rethink Server Sizing
Standardizing on 2 and 4 sockets systems for servers has been an established practice going back to 1996. There were very good reasons for this, but it was so long ago that they have been forgotten. Yet the practice continues unquestioned, almost as a …
Validation, Verification, and Modification
Over the years, I’ve stressed that a schema should support validation and verification of its data, but I’ve never really given a good discussion of what those terms mean. I’d like to add another desirable property, modification, to t …
Female DBAs Make Less Money. Why?
The 2018 Data Professional Salary Survey is open now, and you can look at the live responses as they come in. (To get that in Excel, click File, Download.) As of this writing (Dec 23), there’s already over 2,500 responses, so I’m going to t …
Azure DWH part 22: Dynamic Management Views
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
SQL SERVER – How to Install New Sample Database WideWorldImportersDW.bak
Last year, I have written a blog to install sample database WideWorldImporters SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters. Recently, while I was showing demo to a client, they informed that I don’t have …
Set Up of Windows 10 on New Devices With These Tips
If you received a new computer over the holidays, it will likely be running Microsoft’s Windows 10. Take some time to get things sorted out before you begin using your new device — and use our guidelines to set up your new device for optimum per …
Cascading Update and Delete for SQL Server 2017 Temporal Tables
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
Support for static data added to Source Control for Oracle
With the speed of software development increasing, more and more companies and organizations are recognizing that version controlling code is becoming as important for databases as it is for applications. In recognition of this, Source Control for Orac …
SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task
One of my clients was performing load tests on timesheet application. They noticed that application jobs are failing with below error message about running a new system task. TimesheetSaveFailed (24014) – A severe error occurred on the current co …
How to List All ColumnStore Index with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Index (CL Index) with Table Name in SQL Server? Answer: As ColumnStore Indexes are getting more and more popular, I now a days see lots of questions related to columnstore index. One of the most popular question, I …