Sites anglophones

Power BI Introduction: Visualizing SQL Server Audit Data — Part 9

Publié le 29 novembre 2018 sur

The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Introduction: Workin …

There is a New COUNT in Town

Publié le 29 novembre 2018 sur

We have all been using the COUNT(DISTINCT) function to return row counts for a distinct list of column values in a table for ages. With the introduction of SQL Server 2019, there is a new way to get an estimate of distinct row values and counts for a t …

Tales From Overindexing: Too Many One Column Indexes

Publié le 29 novembre 2018 sur

Master Plan Sometimes you see a query, and it’s hitting one table, and then the query plan looks like a vase full of spaghetti. Usually, there’s a view involved. Usually. Sometimes, there’s just really weird indexing. Here’s A T …

Meeting Preparation for SQL Server Projects

Publié le 29 novembre 2018 sur

Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.

T-SQL Decommenter Part IV

Publié le 29 novembre 2018 sur

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk edi …

SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)

Publié le 29 novembre 2018 sur journey to sqlauthority

Learning never stops when you are a consultant. While doing my recent Comprehensive Database Performance Health Check my client asked an interesting question. He informed that he is not able to see SQL Server Agent node in SQL Server Management St …

How to Troubleshoot Blocking and Deadlocking with Scripts and Tools

Publié le 28 novembre 2018 sur

When you need to find which queries are blocking other queries, your decision comes down to when the blocking happened. Is it happening now, recently, or coming up soon? During a live emergency, start with sp_WhoIsActive. Adam Machanic’s exc …

New Whitepaper: Data Protection and Compliance During Provisioning

Publié le 28 novembre 2018 sur

Data privacy and protection is a large concern across all organizations and knowing how to best approach it can be daunting. Grant Fritchey unpicks US legislations HIPAA and SOX to uncover exactly what is required of you and your team to ensure complia …

SQL Server on Amazon Web Services (AWS)

Publié le 28 novembre 2018 sur

Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazo …

Are You Making the Right Cloud Storage Decisions for SQL Server tempdb?

Publié le 28 novembre 2018 sur

Here’s why selecting the right storage for SQL Server tempdb is critical, and how to determine what will work.

Data Privacy – Are Your Database Processes Fully Compliant?

Publié le 28 novembre 2018 sur journey to sqlauthority

This year has been filled with data privacy and protection concerns. From the introduction of the General Data Protection Regulation (GDPR) and the exposure of data breaches at Cambridge Analytica, Facebook and Under Armour, to new legislation springin …

Getting Sneaky With Forced Parameterization

Publié le 27 novembre 2018 sur

Silly Rules I’ve blogged about some of the silly rules about where Forced Parameterization doesn’t work. One rule that really irked me is this one: The TOP, TABLESAMPLE, HAVING, GROUP BY, ORDER BY, OUTPUT…INTO, or FOR XML clause …

Converting Binary Numbers To Hex

Publié le 27 novembre 2018 sur

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

SQL Server Auditing for HIPAA and SOX – Part 4

Publié le 27 novembre 2018 sur

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.

Cyber Monday special on 2019 live, online classes 6-pack – save $199 per class!

Publié le 27 novembre 2018 sur - paul randall

It’s Cyber Monday today, and now that you’ve finished picking up great deals for your personal life, how about a great deal for your professional life? From now through 12pm PST on Thursday, November 28th 2018, the first 25 people to regist …

Pages :