Sites anglophones

Interview Question of the Week #037 – What are the Properties of Relational Tables?

Publié le 20 septembre 2015 sur journey to sqlauthority

The other day in the interview, I heard this question and it sent me back to my college days as I used to hear similar questions from my professors. Here is the same question again and its answer. Question: What are the properties of the relational tab …

SQL SERVER – Edition Upgrade from Evaluation to Enterprise Core – AlwaysOn Warning!

Publié le 19 septembre 2015 sur journey to sqlauthority

While preparing for a demo about SQL migration, one of the demo was to show the steps needed to upgrade Evaluation edition to full version of SQL Server. The steps are pretty simple and already blogged at many place on the internet. One of my own blog …

SQL Server 2016 Temporal Tables and Type II Data Warehouse Dimensions

Publié le 18 septembre 2015 sur

SQL Server 2016 introduces temporal tables, an interesting and “data warehouse-y” addition to the relational database. So how do temporal tables work? They add a couple columns to a table that are used to track the date a row is inserted or …

Logging and Error Handling for SQL Stored Procedures

Publié le 18 septembre 2015 sur

Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure

SQL SERVER – FIX – Replication Error: SQL Server replication requires the actual server name to make a connection to the server 

Publié le 18 septembre 2015 sur journey to sqlauthority

Replication as a topic is quite old and proven technology. After I saw the introduction of SQL Server AlwaysOn from SQL Server 2012, I hardly see folks talking about replication. For me replication will always be a technology which allows for partial ( …

What’s More Popular: SQL Server 2014, or SQL Server 2005?

Publié le 17 septembre 2015 sur

Sure, you’d much rather work with SQL Server 2014, but what’s more prevalent out in the real world? At Dell DBA Days, I saw a chart that shocked me: SQL Server version popularity as of Sept 2015 That chart shows the number of servers runnin …

Creating SQL databases on Azure Blob storage

Publié le 17 septembre 2015 sur

Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.

Monitoring Availability Group Replica Synchronization

Publié le 17 septembre 2015 sur

If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the secondary replica databases with the primary replica – but there are multiple ways to do this. Jonatha …

SQL SERVER – Notes about scheduler with Operating Systems

Publié le 17 septembre 2015 sur journey to sqlauthority

Last week I visited my hometown and also made a trip to my college to relive some of my learning days. I bumped into one of my professors who was going for a class. I requested to attend and wanted to contribute. The discussion then moved to a core top …

Derive fiscal week using Excel

Publié le 16 septembre 2015 sur

I had to do something in Excel today that might be useful to other folks so sharing it here. I’ve got a A4 sheet sellotaped to my desk that tells me the start and end date of each fiscal week in our fiscal year. Its useful but its only for 2015 and mor …

PASS Elections: Fuzzy Math

Publié le 16 septembre 2015 sur

The following is an observation and not a swipe at the process. As I understand the current process , the regional seats are filled first before the open seats are filled. We have 4 excellent candidates running for 3 seats on the PASS BoD this year. On …

Filtered Indexes and IS NOT NULL

Publié le 16 septembre 2015 sur

Filtered indexes can be tricky. Just getting your queries to use the filtered index can be a real pain. Parameterization may mean it’s “unsafe” to use the filtered index. The optimizer might want the filtered column in your key or inc …

Automated Patching of SQL Server IaaS VMs

Publié le 16 septembre 2015 sur

Marcin Policht gives an overview of automated management features based on the SQL Server IaaS Agent Azure VM extension.

PowerShell Tool Time: Controlling Our Tools

Publié le 16 septembre 2015 sur

The next installment of the Powershell Tool Time series shows you how to manage backup files by

SQL SERVER 2016: Updating Non-Clustered ColumnStore Index Enhancement

Publié le 16 septembre 2015 sur journey to sqlauthority

Sometimes our learnings are questioned and it is important to visit some of my prior blogs to validate the content. This blog is initiated because one of my blog readers who was playing with columnstore index did a lookup to my blog – Updating Da …

Pages :