Sites anglophones


Offline model editor experience for Power BI

Publié le 11 octobre 2017 sur sqlblog.com
 

I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2017/10/10/offline-model-editor-experience-for-power-bi/

How to Do a Free SQL Server Performance Check

Publié le 11 octobre 2017 sur brentozar.com
 

Your client or boss just said, “Find out why this SQL Server is slow.” You’ve already done a free SQL Server health check, and now you wanna investigate deeper. Step 1: Download & run sp_BlitzFirst. Start with wait stats, which te …

Azure Analysis Services scheduled autoscaling and pausing

Publié le 11 octobre 2017 sur sqlblog.com
 

You can read this blog post at this link: https://jorgklein.com/2017/10/11/azure-analysis-services-scheduled-autoscaling/ This blog has moved to https://jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds accordingly. …

Webinar: how to cut time & disk space for database provisioning by 99%

Publié le 11 octobre 2017 sur sqlservercentral.com
 

If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll s …

Network Configuration of SQL Server Always On Availability Groups in Azure

Publié le 11 octobre 2017 sur sqlservercentral.com
 

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in th …

Stairway to SQL Server Agent – Level 2: Job Steps and Subsystems

Publié le 11 octobre 2017 sur sqlservercentral.com
 

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although …

SQL SERVER – 5 Don’ts When Database Corruption is Detected

Publié le 11 octobre 2017 sur journey to sqlauthority
 

Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption. “Hi Pinal, We learned that our database got corrupted. Once we learned this, we immediately ran CHECKDB with Repai …

SQLskills SQL101: Should you kill that long-running transaction?

Publié le 10 octobre 2017 sur sqlskills.com - paul randall
 

As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologi …

SSMS 17.3 is available for download

Publié le 10 octobre 2017 sur sqlblog.com
 

  The latest version of SSMS ( SQL Server Management Studio 17.3 ) is now available to download. There are a bunch of new features in addition to the usual bug fixes but some of the more popular ones are a new wizard to import flat files, increase …

How to Do a Free SQL Server Health Check

Publié le 10 octobre 2017 sur brentozar.com
 

Your boss or client came to you and said, “Give me a quick health check on this SQL Server.” Step 1: Download & run sp_Blitz. Go to our download page and get our First Responder Kit. There’s a bunch of scripts and white papers in …

SSMS 17.3 has Profiler built-in

Publié le 10 octobre 2017 sur sqlblog.com
 

We all know that Profiler and its background functionality SQL Trace has been deprecated since 2012. Right? And we have all switched to using Extended Events (XE), a long time ago, right? No, the reality is that many of us still uses the old tracing in …

The BigData Legacy

Publié le 10 octobre 2017 sur sqlblog.com
 

Trends come along, and trends pass. Some hang around for quite a while, and then move on, and some seem to disappear quickly. Often we’re glad that they’ve gone, but we still bear scars. We live and work differently because they were there. …

How to examine differences with SQL Compare Summary View and SQL View

Publié le 10 octobre 2017 sur sqlservercentral.com
 

In this video, Steve Jones introduces the new Summary View that’s now available in Redgate SQL Compare. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find an …

WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits

Publié le 10 octobre 2017 sur sqlservercentral.com
 

An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.

Data Starvation – Balance Your SQL Server – Part 1

Publié le 10 octobre 2017 sur journey to sqlauthority
 

With the new Intel Skylake CPUs coming out recently it seemed like a good time to discuss CPU resources and how to know if they’re running optimally.  After all, there’s little sense in upgrading your server if your current one is alre …


Pages :