Sites anglophones

[Video] Office Hours 2017/11/08 (With Transcriptions)

Publié le 13 novembre 2017 sur

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

Publié le 13 novembre 2017 sur

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

Publié le 13 novembre 2017 sur

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’

Publié le 13 novembre 2017 sur journey to sqlauthority

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

Publié le 12 novembre 2017 sur

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

Publié le 12 novembre 2017 sur journey to sqlauthority

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)

Publié le 11 novembre 2017 sur

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

Publié le 11 novembre 2017 sur journey to sqlauthority

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

Publié le 11 novembre 2017 sur

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

Publié le 10 novembre 2017 sur

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

Publié le 10 novembre 2017 sur

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

Publié le 10 novembre 2017 sur

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

Publié le 10 novembre 2017 sur

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

Publié le 10 novembre 2017 sur

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

Publié le 10 novembre 2017 sur

The platform exposes data from connected devices within a Salesforce interface and supports automated workflows that trigger customer-related actions.

Pages :