| A community of more than 1,600,000 database professionals and growing |
| | Labor Day 2018 Today is Labor Day in the US, and it's almost always been a holiday for me since I've been working in technology. When I worked in the restaurant business, that was another story as this was usually the last big weekend of the summer before kids went to school and I almost always had to work. I'm back working today. With the schedule this year for SQL in the City, I needed to be over here and prepping. It's also time for me to meet with the product teams for feedback and understanding of where they're going in their plans. So, if you have complaints, criticisms, or suggestions, drop them in the discussion. I have meetings all week with different groups, so I'll bring up any big issues. If someone posts your idea, a nice +1 helps me understand the scale of the issue. Labor Day was set as a holiday for workers, a national holiday that most employers observe. There are different dates for other countries, but quite a few have the same holiday. That being said, plenty of people still need to work, especially in service jobs. Hopefully many of you have this day off, but if not, I hope it's an easy day for you with the US somewhat shut down. If not, maybe you can convince your boss to let you tune into SQL in the City this Wednesday. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | What’s the top challenge faced by SQL Server professionals in 2018? Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report |
| | SQL in the City Streamed SQL in the City Streamed returns with the theme ‘Adapt and thrive as a data professional’. The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate. Register now |
|
|
|
| | | Our all-star speaker line-up of Microsoft MVPs and Redgate team members will be running sessions on the theme ‘Adapt and thrive as a data professional’. More » |
| Additional Articles from SimpleTalk Despite the attention to data privacy and protection caused this year because of the GDPR, regulations governing how data is handled are nothing new. In this article, Robert Sheldon provides an overview of two US regulations, HIPAA and SOX, and explains how these regulations affect DBAs. More » |
| Grant Fritchey from SQLServerCentral Blogs This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New... More » |
| Dustin Ryan from SQLServerCentral Blogs I’ve had a lot of people ask me for this over the past few months and its finally (mostly) ready!... More » |
|
|
| | Today's Question (by Steve Jones): What happens when this code is run? DECLARE @d DATETIMEOFFSET , @c VARCHAR(20) ; SELECT @c = '20180903' ; SELECT @d = @c ; SELECT @d ; |
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: implicit conversion. 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): What does DBCC OUTPUTBUFFER() return? Answer: The hexadecimal code and ASCII results of the output buffer for a spid Explanation: The DBCC OUTPUTBUFFER command returns the hex and ASCII values from the output buffer of a spid, along with an ordering row column. Here is a sample call. Ref: DBCC OUTPUTBUFFER - click here » Discuss this question and answer on the forums |
|
|
| | Aswini G from SQLServerCentral.com Run the script against your server, Please be careful while running the script on prodcution servers. 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. Can't Get BULK INSERT TO ERROR!!! - Hello guy, I was testing my script for bulk insert. But i can't get the rows to error out and... Convert Varchar field - I have a Varchar field with units in inches :( that i need to convert to an integer (Unfortunately the " and... Insert with dynamic SQL and Cursor for variable table/columns according to update list - Hi! I have a bit of a problem for a while. I have updated tables in Database A. These tables gets... Interesting question about NCI's when converting HEAPs to CI's - I've not run into it before because I don't create permanent tables as HEAPs to begin with. I've also not... Mirroring Failover - I have question, Server A is mirrored to Server B when the failover is done server B would be principal and... How to Generate a common unique column for multiple views - I created 3 different views and I need a common column to join these 3 views. There is an AMOUNT... Order of Clustered Index - Let's say, hypothetically, I have a table with three columns--LastName, FirstName, MiddleName and I wanted to create a clustered index... PIVOT - I need help with SQL PIVOT Example SELECT Manufacturer, CarType FROM Vehicles Manufacture Cartype Ford SportsCar GM Truck Ford RAC like capability for SQL 2012 - Hi, Good day everyone just want to ask if sql server 2012 has a capability of load balancing just like what... Balancing Writes - Good Morning Experts, Here is the requirement from client: They have a server A and they want exact replica of server... SQL Server 2016 SP1 (Azure IaaS) slower than SQL 2008 SP2 on premise - I have an issue with a stored proc that uses a cursor (yes, I KNOW THIS ISN'T GOOD) however it... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|