Sites anglophones


Oracle to SQL SERVER Migration – Triggers Used While Migration

Publié le 28 décembre 2016 sur journey to sqlauthority
 

I am a big supporter of working on something that I get used. This is a trend I see that most of us are used to. When was the last time you switched loyalty from one phone to another? I know most of us have multiple devices that we use, but rarely that …

2016: the year in books

Publié le 27 décembre 2016 sur sqlskills.com - paul randall
 

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015) and people have been enjoying it, so here I present the 2016 end-of-year post. I …

The Recording for SSIS Academy: Using the SSIS Catalog, Day 1 is Available

Publié le 27 décembre 2016 sur sqlblog.com
 

The recording for SSIS Academy: Using the SSIS Catalog , Day 1 is now available (registration required)! This delivery of SSIS Academy continues live Wednesday and Thursday (28, 29 Dec 2016). You can learn more about SSIS Execution and Monitoring Wedne …

The Recordings for SSIS Academy: Using the SSIS Catalog are Available

Publié le 27 décembre 2016 sur sqlblog.com
 

The recordings for SSIS Academy: Using the SSIS Catalog, Day 1 , Day 2 , and Day 3 are now available (registration required)! Day 1 focused on creating the SSIS Catalog and SSIS deployment. Day 2 focused on SSIS Execution and Monitoring Wednesday. SSIS …

Intel Processor Architecture 2020

Publié le 27 décembre 2016 sur sqlblog.com
 

There is an article on WCCFtech , that a new Intel processor architecture to succeed the lake processors (Sky, Cannon, Ice and Tiger) will be « faster and leaner » and more interestingly might not be entirely compatible with older software. The original …

Build your Cloud Analytics Solution from an Azure Template

Publié le 27 décembre 2016 sur sqlmag.com
 

Quickly generate building blocks needed for analytics using templates Cloud computing presents a unique platform for generating complex analytics solutions quickly. With the use of pre-build solution templates, Azure provides an easy mechanism to get s …

[Video] Office Hours 2016/12/21 (With Transcriptions)

Publié le 27 décembre 2016 sur brentozar.com
 

This week, Erik and Richie discuss latency, partition tables, SOS_SCHEDULER_YIELD, alerts, nolock, and what people look for in Senior DBA. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscr …

SQL Server v.Next – Linux Installation Step by Step

Publié le 27 décembre 2016 sur sqlservercentral.com
 

An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation. 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 and fix t …

SQL SERVER – How to Automatically Generate SQL Server Documentation ?

Publié le 27 décembre 2016 sur journey to sqlauthority
 

A complete and precise documentation serves a good basis for developers and DBAs during their onboarding to get a general picture of the database they start working with. Creating such a documentation manually takes a lot of time and effort. So you sea …

Extended Events for Tracking Backup and Restore Progress

Publié le 26 décembre 2016 sur sqlservercentral.com
 

Microsoft has introduced new extended events in SQL server 2016 which will give us detailed information about restore and backup process.

SQL SERVER 2016 – Trace Flag 1117 is Discontinued. Use the Options Provided with ALTER DATABASE

Publié le 26 décembre 2016 sur journey to sqlauthority
 

While doing performance tuning for one of my clients, I was looking at ERRORLOG files to understand about their system. I saw that trace flag 1117 and 1118 are enabled via startup parameter. 2016-12-05 06:02:14.440 Server Microsoft SQL Server 2016 (SP1 …

How to Find Number of Times Function Called in SQL Server? – Interview Question of the Week #104

Publié le 25 décembre 2016 sur journey to sqlauthority
 

Question: How to Find Number of Times Function Called in SQL Server? Answer: This is not a real interview question, but it was asked to me during my performance tuning consultancy recently. We were troubleshooting a function which was called quite …

Books are DONE…

Publié le 24 décembre 2016 sur sqlblog.com
 

Finally, I can say I am done with a couple of books I had been working on, pretty much simultanously at times the past few months: Exam Ref 70-762 Developing SQL Databases ( https://www.micro softpressstore.com/store/exam-ref-70-762-developing-sql-data …

SQL SERVER – FIX – Error – Msg 4928, Level 16, State 1. Cannot Alter Column Because it is ‘Enabled for Replication or Change Data Capture’

Publié le 24 décembre 2016 sur journey to sqlauthority
 

One of my Facebook followers sent me an interesting situation, where he faced error related replication or change data capture. Hi Pinal, We have a database in our QA environment which is restored from Production (we have replication set up in Producti …

SQL Server IO Analysis Part 2

Publié le 23 décembre 2016 sur sqlmag.com
 

Never Upset a Nerd In 2010 I wrote a book on Dynamic Management Objects with fellow SQL Server MVP Louis Davidson.  Over the years I’ve grown even more passionate about what these constructs offer to the DBA and Developer alike in identifying (or …


Pages :