 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| A Summit Wrap Up Last week was the 2016 Pass Summit. This is the largest SQL Server specific conference in the world and I was lucky enough to be able to attend. Looking back, I think it was another great conference, with attendees from all over the world. This is the biggest SQL Server specific conference, and the biggest data platform conference for the Microsoft stack. I hope it continues to be so, though I also hope the event doesn't grow much larger. Most of my time was spent at the Redgate Software booth, where I had some great conversations. It was fun, I got quite a few pictures, and had some interesting questions. While many people were very interested in SQL Clone and DPMS, plenty were also starting to do more advanced and automated DLM deployments and testing of their databases. I'm glad to see the database software space maturing. I've got lots to write up and talk about across the next few months, and it's exciting There were also some announcements this week from Microsoft. Apart from the Surface updates, they showcased Azure Analysis Services and the idea of the intelligent database. The latter isn't really anything new, but there is some new marketing, and it seems MIcrosoft is really pushing to use the database more for analysis and processing of data, something that typically has been done more in applications. I wrote about this recently, but certainly Microsoft would prefer that you run R scripts and other analysis of data inside SQL Server. As someone else pointed out, you have expensive CPUs running SQL Server, and this might benefit Microsoft more than you. We also saw some new branding from PASS, with a new logo that I really like. Stated goals from PASS last week were that they want to grow to 2mm members, as well as encompass more than just the SQL Server world. Certainly I appreciate the recognition that there is more to the world than SQL Server, but I hope the organization doesn't lose focus of where it's core audience spends most of their time. Lastly, at this time next year, the first day of the Summit will kick off on Halloween. I've seen the Summit end on this day, but not begin. While my children are older, for many speakers and attendees, this isn't the case. I suspect we will see some drop off in attendence for this reason, and that's fine. While this is a once a year event, you'll only have Halloween with your child, at this age, one time. I certainly understand those of you that choose to skip the event for that reason. I dislike the decision to schedule the conference at this time, but what's done is done. I hope everyone attending had a great time, and those of you that didn't, I hope to see you at the Summit next year, or some other SQL Server event in the next year. If you want to catch me without traveling, I'll be broadcasting from SQL in the City this December 14 and 15, so be sure to sign up. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT |  | Find SQL in your database for free For example, want to rename one of your table columns but are not sure what stored procedures reference it? Using Redgate’s free SSMS add-in, SQL Search, you can search for the column name and find all the stored procedures that use it. Find out more and download now. |
|  | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
|  | 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. |
|
|
|
| |  | Frank A. Banin from SQLServerCentral.com Build and Operationalize scalable Predictive models and intelligent applications using SQL and R. More » |
 | Additional Articles from Database Journal There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server. More » |
 | Steve Jones from SQLServerCentral Blogs One of the things I struggled with a bit was getting test results to appear in VSTS from my builds.... More » |
|
|
| | Today's Question (by Steve Jones): I have an amazing Halloween application that allows parents and children to track their costumes. We want to enable Temporal support, but we cannot update the application in time for today to insert data into new columns. What should we do? |
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: Temporal Tables. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
ADVERTISEMENT | Build, publish, and maintain paginated and mobile reports using the expert tips and best practices contained in this hands-on guide. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2016 Reporting Services, Fifth Edition, fully explains the process of creating and distributing reports and shows how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. Get your copy from Amazon today. |  | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a SQL Audit set up and running on SQL Server 2016. This audit has a single server audit specification enabled and running with it. I find that the audit is no longer needed, so I decided to drop the session. What must I do? Answer: Stop the server audit specification and the server audit, then issue a DROP SERVER AUDIT Explanation: You can drop a server audit without dropping the audit specifications. These will be orphaned and can be mapped to another server audit. Ref: DROP SERVER AUDIT - https://msdn.microsoft.com/en-us/library/cc280899.aspx
» Discuss this question and answer on the forums |
|
|
| | Doran Mackay from SQLServerCentral.com Runs on top of OlaHallengren's Logging table. Create this view, and change the path to the commandlog table if needed. A common query for me is select * from vcommandlog where Fragmentation > 25 and cast(starttime as date) = cast(getdate() as date) go select * from vcommandlog where DurationInSeconds > 60 and cast(starttime as date) = cast(getdate() as date) go More » |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. Concurrency - Please Provide Comments - Hi all I have a question about concurrency. Let me provide some set-up code first. [code="sql"]DROP TABLE IF EXISTS dbo.Test1 CREATE TABLE dbo.Test1 ( PK... list of db features - Is there a query to get a list of db features I tried using SQL server central and then tools and... creating a sequence of number starting or each group of ID - I have 3 source table and have to union them all source 1: Id name car 1 aaa BMW 1 aaa... Completing Fixed Sets With Another Table - Hi, I'm having some trouble finding a solution to a problem, its been a few hours now and I think I... ColumnStore Index - We have a DataWarehouse with Large Fact Tables . The Some of the tables have about 30 to 60 Columns and... Theron said - [url=http://www.colorado.edu/law/sites/default/files/webform/Packers-vs-Falcons-Live-Stream-Gamecast-30-OCT-2016-Georgia-Dome-EspnFox.PDF]Packers vs Falcons Live Streaming[/url] Image Revive Reviews@ healthsuppfacts - Before you take a gander at the healthy skin items available, you should know that there are various elements that... in the Novembe - [url=https://www.rit.edu/dubai/sites/rit.edu.dubai/files/webform/Jets-vs-Browns-Live-Stream-Match-Sopcast-30-OCT-2016-FirstEnergy-Stadium-FOXEspn.PDF]Jets vs Browns Live Streaming[/url] "I've had circumstances where individuals - "I've had circumstances where individuals have required root courses in light of the way that they've overbleached, where tissues were... White Light Smile Review - Fast-Acting Teeth Whitener? - Besides, of current circumstances can be a structure for controlling the level of signs you experience. Reducing your presentation to... parry attacks from - [url=https://www.linkedin.com/pulse/isgemini2ascam-gemini-2-review-how-mac-log-john-don]Gemini 2 Review[/url] Not only must he - [url=https://www.linkedin.com/pulse/orioncashcode2-orion-code-review-scam-legit-software-details-de-lacy]Orion Code Review[/url] sql backup - Do you have any idea how long it might take to sql backup for 600 gb. Thank you HELP! I've got to give a talk to our local .NET geek meet on SQL server - Hi guys, I have agreed (foolishly) to give a 30-minute presentation to our local .NET developers meeting on entitled "Why your... SQL help - how to write a query with reference to its own results - Hi, could anybody help me please with this: I would like to write a query which retrieves this information: id... Simple XML query - Hi folks, this is probably a simple one for someone. I've confused myself over (i'm a beginner with XML queries)... Paris Saint Germain and it would - [url=https://www.rit.edu/dubai/sites/rit.edu.dubai/files/webform/br-bengals-vs-redskins-live-stream-nfl-week-8-gameguide-30-oct-2016.pdf]Bengals vs Redskins Live Streaming[/url] Calculate Percent of Readmission - Hello all, I need some help from you great minds here. I would like some insight on how to calculate the... Azure certification for SQL DBA - Hello, I know this is an off topic post, but please help me out. I am a sql server dba with 10... Applying tSQLt on existing datawarehouse - Hi, I'm fairly new to tSQLt and looking for a bit of advice from more experienced folk :) We have a live... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| 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: webmaster@sqlservercentral.com |
|
|