| A community of more than 1,600,000 database professionals and growing |
| | | SQL in the City 2016 It's time for SQL in the City 2016 to start today. Actually, by the time some of you read this, we may already be underway. This year the event is being broadcast from the Redgate Software offices in Cambridge, UK. Along with Grant Fritchey and a number of other Redgaters, we're holding our annual conference live for the world to watch. In fact, to ensure everyone can watch, we're going to broadcast both today and tomorrow (Dec 15) at different times to reach the entire world. If you can't tune in today, come back tomorrow as the content is the same, just about 4 hours later. That means an early day in the office for me today, and then a late one tomorrow, but it's worth it to give you a fun show. I've enjoyed being a part of SQL in the City for many years, in quite a few cities around the US as well as London. Each year we spend time trying to showcase new products and features from Redgate that can better help you develop software. That's the mission at Redgate. We want to make you more productive as you build applications on top of SQL Server. Part of doing that is showing you examples and providing education in addition to selling software. As an evangelist, I've been proud that Redgate continues to give back to the community and invests heavily in SQLServerCentral, Simple Talk, and many other conferences and events around the world. We truly do want to be a part of the #sqlfamily and try to ensure that every one of us gets better at our job over time. To me this is one of the great things about the SQL Server community in that we all support, inspire, assist, and share with each other. I'm happy to help contribute what I can to educate SQL Server professionals every day. This should be a fun couple of days, and I hope you enjoy the sessions we've been developing this fall. We've got some great new products that have been under development in 2016 and should be releasing soon. I think you'll like what we've been working on. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.2MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | Not enough hours in your day? The SQL Toolbelt lets you reduce the time spent on SQL Server development and administration. Cambridge University developer David Spaxman, for example, says: “I’m saving 10-12 hours a week using the SQL Toolbelt.” Learn how you can double your productivity, speed up deployments and protect your data. Download a free trial. |
| | | | New Redgate SQL Compare 12 has landed! SQL Compare 12 has landed with a brand new user interface, support for SQL Server 2016, and a wealth of fixes and improvements. Check out this blog post from Redgate's Carly Meichen to hear more about what’s new, why the team have built it, and how. Read now. |
| | | | Track schema changes for free DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool. ... |
|
|
|
| | | | | Yell McGuyer from SQLServerCentral.com Using an ORM with SQL Server introduces unique challenges. I have listed a few of my experiences, hoping it can help someone. More » |
| | Press Release from Redgate When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do. More » |
| | Additional Articles from SimpleTalk Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how. More » |
| | Andrew Pruski from SQLServerCentral Blogs This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing... More » |
|
|
| | | Today's Question (by Grant Fritchey): These two queries produce an identical graphical execution plan with identical estimated costs: -- Query 1 SELECT sd.OrderQty, pr.Name FROM (SELECT * FROM Sales.SalesOrderDetail AS sod ) AS sd JOIN (SELECT * FROM Production.Product AS p ) AS pr ON pr.ProductID = sd.ProductID WHERE sd.SalesOrderID = 52777; -- Query 2 SELECT sod.OrderQty, p.Name FROM Sales.SalesOrderDetail AS sod JOIN Production.Product AS p ON p.ProductID = sod.ProductID WHERE sod.SalesOrderID = 52777; How can you identify any differences? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Execution Plans. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): Where can I store the certificates for my Always Encrypted Column Master Key?
Answer: In the Azure Key Vault, the User Windows Certificate Store or the Local Computer Windows Certificate Store Explanation: The Certificates that are used as the Column Master Keys can be stored in the Azure Key Vault, or either of the Windows Certificate Stores on a machine (USer or Comptuer). Ref: Overview of Key Management for Always Encrypted - https://msdn.microsoft.com/en-us/library/mt708953.aspx » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Select query inside procedure taking long time, clustered indexes doing scans, need suggestion - I have a procedure, which is running very slow, and is being timed out without returning any records. [Reports] Table... DBA without sa rights??? - Our network administrator, whom I'll affectionately refer to as DCD (Data Center _ick), has decided that I no longer deserve... GROUP BY in SQL Server 2014 - Hello all, The same query with a group by clause I try to run on SQL Server 2005 and on SQl... Converting date and/or time from character string. - Hi all, I have a basic problem (I hope) whereas I'm trying to insert 4m rows from one table to... Split a number in close equal number in sql - Hello All, I am facing problem while spliting a number in closest equality. say i want to divide 11 into 4... Replace multiple row with sequence value - Hi Folks, I am new to SQL and i have table which has column FULLNAME (Last name, firstname) & USER EMAIL ([email protected])... How to identify that Dynamic Sql fail? - I have created one trigger,inside it executing dynamic sql. Here is sample script When I specifying @Text to some value,it work... Let the optimizer do it's thing -- wrong - I've heard this advice everywhere. Don't do things to change the way the sql optimizer produces plans etc. "it's smart... SSMS: First connection to DBMS takes over 15 minutes - So I have come across an odd issue on my workstation that I was hoping someone on here might be... Bitwise & NULL - I have a large number of yes/no columns for a table. Rather than creating a bit field for each, I'd... trying to get rid of clustered index scan - I have statement below which does a merge join but does a clustered index scan with over 2 million rows... Data update - I have data "2016-11-10 12:12:42.100" in table column UPDATED_DATE. my where clause is ... WHERE CONVERT(varchar(11),UPDATED_DATE,103) BETWEEN '01/12/2016' and '13/12/2016' order by... Query to join three tables but filter out subset of the data - I'm struggling to develop a query to pull data from a few tables while excluding some portion of the data.... SQL Snapshot - Hello, I need to be able to test something (which will change some data on the big databases) and after revert... SSRS 2012 Standards for Report Server Configuration and Report Development? - Just wondering if anyone has some suggestions on standards for SSRS Report Server Configuration and Report Development? I have come... Poweshell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list of servers - create a c:\servers.txt file with list of servers and copy the following into a file .ps1 enjoy function getwmiinfo ($svr) { gwmi -query "select... Multiple Joins on Fact Table - Hi, I am building a DW which will load data from 2 separate sources. Each source will populate the Broker Dim table... Good to have Multiple Data Warehouses? - Interesting debate came up on data warehousing. Is it good to have multiple data warehouses or just one? To add some... How to Create Linked Server for a MySQL database using SQL Server Management Studio - It took me about a day to figure this out, so I thought I'd try to save someone else the... Number of weeks between two dates - . |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
