| A community of more than 1,600,000 database professionals and growing |
| | | A Summit Just North of The Big Easy I'm off today, traveling down to The Big Easy, New Orleans for a beignet. Well, not just a beignet, but also because I'll be speaking at SQL Saturday #628 in Baton Rouge tomorrow. It's easier, and more fun, to fly into New Orleans, so I'll do that, have a quick snack at Cafe Dumonde and then drive up to Baton Rouge. It's an easy, relaxing drive, and a nice (albeit warm) part of the country. Hopefully I'll arrive in time for a quick jog around University Lake. This is the 9th SQL Saturday for Baton Rouge, one of the oldest (they started with #17) and this is my fifth time going. I always enjoy the people and crowds down there and this is one of the largest SQL Saturday events in the country. The schedule has 12 tracks, and with over 500 people coming, they need that many to keep from having every room overcrowded. I have two sessions, and I'm looking forward to seeing quite a few others from other speakers, learning a bit more about SQL Server. I think it's great that this event includes lots of developers from the area and covers a huge variety of topics. People come from all over the area, from Texas to West Florida, and sometimes from Arkansas and Tennesee. There is a wide variety of data related, and a few developer, sessions, as well as a nice career track. There is a huge thirst for knowledge, and for some reason SQL Saturday Baton Rouge on the campus of LSU attracts many people from all over. It's great that we have people in our community that will put together a large event to help others improve their careers and get excited about databases and software. Holding an event like this takes a lot of work, and my hat is off to the organizers. They do a fantastic job and really put on a great event for everyone. I'm glad we have large events like this, and I also am glad we have people putting on smaller events all over the world. We have a fantastic SQL Server community, and it's always a treat to get accepted to present. I hope to see some of you tomorrow and many more in the future. 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.4MB) 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 | | | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
| | | | Free whitepaper: Solving the database deployment problem with Database DevOps Learn how to extend DevOps practices to SQL Server databases, so you can spend less time managing deployment pain and more time adding value. Download the free whitepaper |
|
|
|
| | | | | Additional Articles from MSSQLTips.com Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task. More » |
| | Site Owners from Redgate Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They're open to accepting remote workers, so if you're interested, there's no excuse not to go ahead and apply! More » |
| | Steve Jones from SQLServerCentral Blogs I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code... More » |
|
|
| | | Today's Question (by Steve Jones): I run this code, and I get a NULL because this isn't valid XML. SELECT TRY_CONVERT(XML, '') What is returned with this code? SELECT TRY_CONVERT(XML, 4) |
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: TRY_CONVERT(). 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 | | SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a set of basketball statistics and I want to analyze a player. I'm hoping to get the number of points that a player scored and the difference from his first year with that team. For J.R. Reid (against whom I played as a kid), I have this data: year team pts ------- -------- -------------------------------------------------- 1989 CHA 908 1990 CHA 902 1991 CHA 560 1992 CHA 127 1992 TOT 780 1992 SAS 653 1993 SAS 627 1994 SAS 563 1995 SAS 208 1995 TOT 427 1995 NYK 219 I have this query with first_Value(), but it doesn't seem to work. Why not? SELECT TOP 10 year, team, CAST(pts AS INT) AS 'Season Points', CAST(pts AS INT) - FIRST_VALUE(pts) OVER (ORDER BY (SELECT NULL) ) AS 'Difference from first year with team' FROM dbo.player_regular_season WHERE firstname = 'J.R.' AND lastname = 'Reid' ORDER BY [year]; The results of my query: year team Season Points Difference from first year with team ------ ----- ------------- ------------------------------------ 1989 CHA 908 0 1990 CHA 902 -6 1991 CHA 560 -348 1992 CHA 127 -781 1992 TOT 780 -128 1992 SAS 653 -255 1993 SAS 627 -281 1994 SAS 563 -345 1995 SAS 208 -700 1995 TOT 427 -481
Answer: I need this code: FIRST_VALUE(pts) OVER (Partition by Team ORDER BY Year) Explanation: The problem is that I don't have the proper partition, or ordering. I want the data ordered by year in each window. This gives me the data in year order, so that I am comparing the data chronologically. Within the ordering, I want to divide the data by team, hence the partition here. This will give me the first value for each year and team for comparison with the current row. Ref: FIRST_VALUE - click here » 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. Upgrade from SQL Server 2012 to SQL Server 2016 Inplace - Hi, recently i have upgraded my sql server from 2012 to 2016 using inplace .but after restart of system ssms is... After sql upgrade from sql 2014 to sql 2016 failover on 2 node windows cluster fails - I have a 2 node windows cluster set up. node 1 (active node) fails to roll over to node 2... SQL Server geo-cluster 2016 - Dear Everyone Ikeep reading online that its not recommended to virtualize SQL Server clusters (4 nodes) Image string select in sql server table - Hi All, my tbale have a 150000 records i this records some of records have images.how can i select only... Deny Permissions On Object(s) Except For Certain Users - I've been tasked with making sure all users, except for a couple, have at most select permission on some tables. ... need list of logins at the server level - My issue is we removed several users at the server level and left them at the database level. I'm trying... Synonyms causing performance issue - database on same server - I have synonyms created that point to a database on the same server. I have been using them for 2 years... Getting error with Bulk Insert when data is encoded with double qoute - Hi, My table is getting loaded with 0 rows .i am using the below format file to load. Table DDL CREATE TABLE .( ... Next row begins - Ok so what I am wanting to do is fill in rows with information that is missing from a file.... SQL Server STATISTICS - Hi All, We have a migration activity coming up where we backup our SQL server databases and restore on a different... Database not available - Hi hope someone can assist with this. We have a database running on SQL 2008 in our production environment which recently... Report Builder connection issue - Hi Guys, I have just setup a new reporting server and configured SSRS. I can connect to the report server from... Display all the data but calculate only some data - Hi ,How can I show all the values for different month and only calculate some based on the condition in... Powershell script transfers entire directory? - I've got a powershell script I'm using to send one file via SFTP. The only problem? It's copying everything in... Cannot deploy to SSISDB - Hhhhh Send a email if a file has not loaded 7 days afetr the 24 of the month - Every month on the 24th we receive a invoice for the months purchases. It is always generated for the 25th through... Calculated Query Help - Hi, I am struggling to grasp on how to calculate in SQL where there is a fixed Qty in stock and... BCP error -Unable to open BCP host data-file - SQLState = S1000, NativeError = 0 Error = Unable to open BCP host data-file NULL I am getitng the above error when i... no replicated transactions are available - I am replicating data to two different subscripton databases from the same publisher DB. One subscription works fine while the other... Potential presentation idea: SQL Server for absolute beginners - So, I took today off from work to prepare and travel to SQL Saturday #517, and something occurred to me... |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
