Sites anglophones


What are Ports Needed to Configure Log Shipping? – Interview Question of the Week #169

Publié le 15 avril 2018 sur journey to sqlauthority
 

Question: What are Ports Needed to Configure Log Shipping? Answer: I thought it would be easy to find that from the internet but looks like it was not as easy as I thought. So, in this blog, we would learn about ports needed for log shipping. …

SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name

Publié le 14 avril 2018 sur journey to sqlauthority
 

Before you read further, let me warn you that Logon triggers are potentially evil and might also end up locking everyone out of the instance. Be careful! Don’t just copy paste the code and create the trigger, you might end up in downtime to fix t …

Training Week: Data Science Fundamentals with a Real Project

Publié le 13 avril 2018 sur brentozar.com
 

When Steph Locke first ran her Data Science Fundamentals with R class, I was amazed at the work she put into the hands-on labs for the students. They had real challenges to help them learn how to model different kinds of data and learn answers fro …

SSIS Design Pattern – Staging Fixed Width Flat Files

Publié le 13 avril 2018 sur sqlservercentral.com
 

Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

Publié le 13 avril 2018 sur sqlservercentral.com
 

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with ‘XYZ’?

SQL SERVER – Error: 1067 – Unable to Bring Analysis Service Online in Cluster

Publié le 13 avril 2018 sur journey to sqlauthority
 

Even after working with many clients on various issues (Always On, Deployment, Performance Tuning) I always get new challenges as a part of my freelancing job. One thing I have learned is that one needs a systematic approach to diagnose the issue and, …

Training Week: Announcing Ben Miller’s PowerShell for DBAs: Level 2

Publié le 12 avril 2018 sur brentozar.com
 

Drew Furgiuele‘s PowerShell for DBAs class has been getting rave reviews, including: “Fantastic class! This is the best online training I’ve ever taken. Very slick setup using the webinar for learning, an AWS VM for labs, and slack fo …

Extending DevOps to the database: branching and merging

Publié le 12 avril 2018 sur sqlservercentral.com
 

This webinar will focus on branching and merging with Visual Studio Team Services (VSTS) as part of a DevOps approach to database development. It will also show how Redgate tools plug into VSTS to enable the build, test and deployment of your database …

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

Publié le 12 avril 2018 sur sqlservercentral.com
 

Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon’s Relational Database Service.

Monitor Query Performance Using Query Store in SQL Server

Publié le 12 avril 2018 sur sqlservercentral.com
 

The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.

SQLPASS Pre-Con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs

Publié le 12 avril 2018 sur journey to sqlauthority
 

If you are traveling to SQL PASS, Seattle this year, you do not want to miss out on my pre-con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs. This session is going to be amazing fun and very unique. It is full day demo-o …

PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality

Publié le 11 avril 2018 sur sqlskills.com - glen berry
 

PASS has publicly announced their Pre-conference Sessions for the PASS Summit 2018 in Seattle, WA. There are seven sessions on Monday, November 5, 2018, and nine sessions on Tuesday, November 6, 2018. There are good sessions on both days, from many wel …

Training Week: Announcing Edwin’s New Class on Failover Clustered Instances

Publié le 11 avril 2018 sur brentozar.com
 

This week, we’ve got a bunch of announcements about new training classes. Next up, Edwin Sarmiento: his 3-day Always On Availability Group class has been getting great reviews: “This class is fantastic. There is no filler, and no needless r …

Training Week: PASS Summit 2018 Pre-Con: Performance Tuning in 21 Demos

Publié le 11 avril 2018 sur brentozar.com
 

Performance Tuning in 21 Demos You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. You don’t like learning by watching slides or reading white papers – you want to jump right into the co …

Software Testing Skills Must Shift with AI

Publié le 11 avril 2018 sur sqlservercentral.com
 

Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.


Pages :