Sites anglophones

SQL SERVER 2016 – InMemory OLTP LOB Datatype Enhancement

Publié le 5 juillet 2016 sur journey to sqlauthority

My exploration with SQL Server 2016 features are just continuing and I am delighted every other day to figure out something new been added to the capabilities which in the opinion were of limited capacity in the prior versions of SQL Server. I will spa …

Breaking News: 2016 Query Store cleanup doesn’t work on Standard or Express Editions

Publié le 4 juillet 2016 sur

If you’re using SQL Server 2016’s awesome new feature, Query Store, there’s a new bug with automatic cleanup. Books Online explains: Automatic data cleanup fails on editions other than Enterprise and Developer. Consequently, space use …

Screenshot Interview Question: “What would you do if you saw this?”

Publié le 4 juillet 2016 sur

In this week’s episode of our screenshot interview series, you’re applying for a database professional position who will be on call. You’re not necessarily the DBA, but you’re a member of the team on rotation. While you …

Difference between SQL Server Unique Indexes and Unique Constraints

Publié le 4 juillet 2016 sur

Uniqueness of values in specific columns can be enforced in a SQL Server table by creating a unique constraint or a unique index on those columns. In this article, Sergey Gigoyan looks at what the differences between the two are, and how SQL Server han …

Stairway to SQL Server Virtualization Level 1: What is Virtualization?

Publié le 4 juillet 2016 sur

The first level in the Stairway to Virtualization introduces the concept of virtualized servers as well as the terminology and benefits of implementing the technology.

SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion

Publié le 4 juillet 2016 sur journey to sqlauthority

Rarely, it also happens when someone becomes accidental DBA and may get stumped with simple things. This blog is result of troubleshooting which I have done for a company where I found one such DBA. I don’t say you cannot become a DBA in this man …

How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078

Publié le 3 juillet 2016 sur journey to sqlauthority

Just the other day I was busy during a performance tuning exercise I explained to the team of DBA that how much log file is critical and important for their performance. Once I was explaining the importance and role of the LDF file in the performance, …

[Video] Office Hours 2016/06/29 (With Transcriptions)

Publié le 2 juillet 2016 sur

This week, Erik, Richie, Doug, and Angie discuss a script for getting more information on a specific index, using partition tables, shrinking data and log files, stress testing SQL servers, as well as some entertaining things to ask Siri! Her …

SQL SERVER – Unable to cast object of type ‘System.DBNull’ to type ‘System.String’. (Microsoft.SqlServer.Smo)

Publié le 2 juillet 2016 sur journey to sqlauthority

When you are driving on a highway, you look forward to the sign boards give you guidance while you are busy driving. These sign boards tell you when your exit is approaching and how you should be dealing with the same. I consider such sign boards insid …

SQL Server 2016 and HPE Superdome X Security

Publié le 1 juillet 2016 sur

With the continued growth of the cloud and the ubiquity of end user devices, security has become one of the foremost concerns for database and IT professionals. With the release of SQL Server 2016, Microsoft has made security an even higher priority. r …

New course: Replacing Profiler with Extended Events

Publié le 1 juillet 2016 sur - paul randall

Erin’s new course is called SQL Server: Replacing Profiler with Extended Events and is just under 2.5 hours long. It’s based on her very popular user group/conference session and will help you move painlessly from using Profi …

Availability Group Direct Seeding: TDE’s Frenemy

Publié le 1 juillet 2016 sur

From the Mailbag In another post I did on Direct Seeding, reader Bryan Aubuchon asked if it plays nicely with TDE. I’ll be honest with you, TDE is one of the last things I test interoperability with. It’s annoying that it breaks Instant Fil …

SSIS Design Pattern – Staging Delimited Flat Files

Publié le 1 juillet 2016 sur

Learn how to use SSIS to load Delimited Flat Files to staging tables. 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 the root causes of disk I/O …

The cmdlets Are Coming! The cmdlets Are Coming!

Publié le 1 juillet 2016 sur

A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you’d like to see.

Mutating Table Error In Oracle: Why It Happens And What You Can Do About It

Publié le 1 juillet 2016 sur

David Fitzjarrell takes a look at why the mutating table error is thrown, why it’s not going to create data problems, and how to possibly fix it.

Pages :