[Video] Office Hours 2017/11/08 (With Transcriptions)
This week, Richie and Tara discuss Richie’s current projects, Availability Groups, offloading reads and backups, applying service packs, whether production should ship agent jobs to production recovery server, security checks and scans in SQL Ser …
Alert Inbox Grouping Preview in SQL Monitor
The SQL Monitor team are hard at work, improving how you manage your alerts. Find out more about the changes they’re making, and how you can try an online demo of the new features now.
Dynamically Create Warehouse Dimensions
Here’s a data warehouse design pattern to speed up multi-value dimension creation.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
Due to my connect with my many clients, learning never stops for me. Almost every day someone sends me email for quick 55 minute consultation. You can read more about it over here about how to fix error related to SQL Catalog. This time it was a busine …
Lateral Thinking: Transitive Closure Clustering with SQL Server, UDA and JSON
For a feature we’re developing in Sensoria, we had to solve one of the well-know, yet hard to solve, problem with data and relationships between elements in a data set. While there are several ways to solve the same problem (just search for …
How to Validate Email Address in SQL Server? – Interview Question of the Week #147
Question: How to Validate Email Address in SQL Server? Answer: I just received this question in an email a week ago. The matter of fact, I have answered this email quite a many times before on various forums and on social media. However, when I se …
ITPro SnapShot: What Else Happened This Week? (November 3-10, 2017)
ITPro SnapShot offers a short and snappy round-up on recent industry-related announcements and news around the globe.
SQL SERVER – Installation Error – Updating Permission Setting for File Failed
My client contacted me for a quick assistance in a setup trouble. She informed it’s a brand-new install and failing at the end. She was installing SQL Server 2016 on Windows Server 2016. Let us learn about how to fix Installation Error. Belo …
FAQs: Using a KMS Server; Securing Virtual Networks and Physical Machines
Three times a week (Monday/Wednesday/Friday), John Savill tackles your most pressing IT questions. Read through the FAQ archives, or send him your questions via email. This batch: how to quickly configure a machine to use a specific KMS server, and how …
Red Hat and Integration Take Center Stage at OpenStack Summit
Red Hat previews its upcoming release of the cloud platform while the OpenStack Foundation talks product integration.
IBM Ups Pressure on Rivals With Quantum Computer Prototype
IBM said Friday it has created a prototype 50 qubit quantum computer. A machine this size is believed to be close to the threshold at which it could perform tasks beyond the reach of conventional supercomputers.
Erasure-as-a-Service Offering Targets Expansion through Partners
Fujitsu and 13 other partners will provide the data Erasure-as-a-Service assistance to customers who need to wipe drives.
How to Test Your Corruption Alerts
You’ve been such a good database administrator. You followed the setup checklist in our First Responder Kit. You ran sp_Blitz. You set up email alerts for common issues. You run CHECKDB as frequently as practical – weekly, or maybe even dai …
Mixing MongoDB and Relational Databases in the Enterprise
Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rap …
Salesforce’s IoT Explorer exposes IoT data to lines of business
The platform exposes data from connected devices within a Salesforce interface and supports automated workflows that trigger customer-related actions.