Sites anglophones


PowerShell Scripting to Replicate Cloud & SaaS Data to SQL Server

Publié le 1 juin 2017 sur sqlservercentral.com
 

Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell

SQL SERVER – Master Database in Single User Mode – A Serious Issue

Publié le 1 juin 2017 sur journey to sqlauthority
 

There are some weird situations which I see in SQL Server. This is also a one of the surprising situation. One of my clients reported via below screen shot. Let us see the issue of Master Database in Single User Mode. Interesting enough, there was no i …

Graph data processing with SQL Server 2017 and Azure SQL DB

Publié le 31 mai 2017 sur sqlblog.com
 

As soon I saw that SQL Server 2017 supports graph database concepts (queries and modeling) I started to play with it and wanted to know more. And so I took the chance to ask to the program managers working on that feature to come and speak at the PASS …

SQLskills SQL101: How can a SELECT cause a database to change?

Publié le 31 mai 2017 sur sqlskills.com - paul randall
 

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used t …

SQL Server 2016 Distributed Replay Errors

Publié le 31 mai 2017 sur sqlskills - jonathan kehayas
 

If you’ve tried to install and configure Distributed Replay in SQL Server 2016, I wouldn’t be surprised to hear that you ran into all sorts of problems and probably didn’t end up getting it to work in a multi-client setup and eventual …

Direct Seeding: I’ve Got A Wizard And You Don’t

Publié le 31 mai 2017 sur brentozar.com
 

A commenter commented That the “New AG Wizard” in SSMS 2017 had surfaced the Direct Seeding mode for AGs. I was pretty psyched about this because I think it’s a great feature addition to AGs that can solve for a pretty big hump that p …

How to design beautiful dashboards in Power BI – the cure: 15 rules for everyone #powerbi

Publié le 31 mai 2017 sur sqlblog.com
 

Is there a secret recipe to create a beautiful dashboard? Why do we need to use “beautiful”? Would “useful” be a better adjective? If you think for a moment, you know that we are attracted by the “beautiful”. It is i …

New Data Driven Podcast: Jen Underwood on Data Visualization and Automating Data Science

Publié le 31 mai 2017 sur sqlblog.com
 

Frank La Vigne and I are launching Data Driven this week. We are honored Jen Underwood ( blog | Impact Analytix ) agreed to be our very first guest! Jen was an awesome guest! We talked about unicorns, the relationship between data science, machine lear …

Stairway to U-SQL Level 14: Local U-SQL Scalar Functions with C#

Publié le 31 mai 2017 sur sqlservercentral.com
 

Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.

Tempdb size resets after a SQL Server service restart

Publié le 31 mai 2017 sur sqlservercentral.com
 

Have you ever checked the size of the SQL Server tempdb after restarting SQL Server to find that it’s reset? Simon Liew explains this behaviour.

Validate Integer and Decimal Values in SQL Server

Publié le 31 mai 2017 sur sqlservercentral.com
 

Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.

SQL SERVER – FIX : Error: 3456, Severity: 21 – Could not redo log record (xx:xx:xx), for transaction ID (x:xx), on page (x:xx), database ‘master’

Publié le 31 mai 2017 sur journey to sqlauthority
 

While I work on performance tuning most of the time, I do provide consultancy on issues which can be resolved quickly. These are the engagement where I get a lot of content for my blogs as well. Let us learn about the error related to redo log record. …

Using Group Managed Service Accounts for SQL Server

Publié le 30 mai 2017 sur sqlskills - jonathan kehayas
 

This afternoon I ran into an issue after rebooting one of my lab environment VM’s for SQL Server 2016 to give the VM more memory to allow some tests I’m doing with in-memory OLTP.  When the VM rebooted I tried to connect to SQL Server …

Announcing sp_BlitzBackups: Check Yourself Before You Wreck Yourself.

Publié le 30 mai 2017 sur brentozar.com
 

If one of your SQL Servers went down at some point over the last week: What’s the most data you could have lost? What’s the longest you would have been down for? To find out, Erik and I (mostly Erik) wrote sp_BlitzBackups (sure, blame …

Announcing Data Driven–a New Data Science Podcast!

Publié le 30 mai 2017 sur sqlblog.com
 

I am honored to announce Data Driven – a new Data Science podcast hosted by Frank La Vigne ( blog | @Tableteer ) and me! Visit our site and: Check out new episodes . Learn more from the DataDriven blog . Become a Data Driver ! Learn more about th …


Pages :