| A community of more than 1,600,000 database professionals and growing |
| | | All DevOps All Day There is no shortage of webinar events taking place for technology professionals. From our monthly Redgate DevOps webinars to the GroupBy conference to PASS Virtual chapters, there's a huge set of online events that you can attend and learn from. It's gotten to the point where you could have a full time job watching webinars if you could find someone to fund your efforts. Every year PASS does a 24 Hours of PASS, which is a neat event where 24 hour long sessions in a row are broadcast. It's a lot of work to get this going, and certainly not many people want to watch 24 hours in a row, but it does seem to be fun. That same idea is being taken a step further tomorrow with All Day DevOps 2017. There's still time to register and attend a few sessions, or even throw a party (or join one) with fellow technical professionals. Maybe this is a good way to take a break from work and still be productive. This might be one of the cheaper conferences you could attend this year. Maybe you can even convince the boss to get some t-shirts with the savings. As you might have guessed, I'm a part of this event. I submitted to DevOps East, a conference in Orlando next month, but they also picked me up for the online event, so I'll be watching and speaking tomorrow. This is an interesting format as it's not just 24 sessions. It's over 100 sessions, with 2, 3, or 6 sessions going on at the same time. There are some long sessions, some short ones, all covering different aspects of what we call DevOps. Whether you think DevOps is a fad, the idea is silly, or are excited to start building software better and faster, I'd urge you to take a few minutes to scan the schedule and see if there is anything that catches your eye. You might learn a bit on how to change your culture, or improve security, or implement automation. There are even some testing sessions, which I'm looking forward to watching. Whether you're a believer or a skeptic, learn a bit more about DevOps and have an informed opinion. Don't just judge the movement on the media hype. Listen to some real technical people talk about the ways that they are trying to improve software. 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.1MB) 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 | | | | Database DevOps Demo Webinar Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now |
| | | | Don’t just fix SQL Server problems, prevent them from happening SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial |
|
|
|
| | | | | Daniel Calbimonte from SQLServerCentral.com In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore. More » |
| | Additional Articles from Database Journal Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features. More » |
| | A common thread behind the software Redgate develop is a problem or issue they’ve come across in the software development process. They then adopt the software themselves, which gives us a real understanding of the features that need to be developed further. To gain a deeper insight into SQL Clone, this interview was conducted with Joseph Woodhouse, Redgate's IT Manager, to find out about how it’s being used to implement a new database provisioning process at Redgate. More » |
| | Grant Fritchey from SQLServerCentral Blogs T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t... More » |
| | Dharmendra Keshari from SQLServerCentral Blogs In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be... More » |
|
|
| | | Today's Question (by Matt Crowley): What will be the value assigned to the variable @str? DECLARE @str VARCHAR(100) ; SELECT @str = ISNULL(@@SERVERNAME, 'hello') WHERE 1 = 0 ; SELECT @str ; |
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: T-SQL. 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 | | Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I want to create a Python list and then add the first 3 values of the Fibonacci sequence to it. I have this: Fib = [] Which of these completes the code?
Answer: Fib.extend([1,2,3]) Explanation: The .append() method works for single values. We could do this: Fib.append(1) Fib.append(2) Fib.append(3) or some of the numerous iterator methods of accomplishing the same thing. The secnod option is invalid syntax, as is the third. The .extend() method allows a list to be added to the current list. Ref: How to append multiple items to a list - 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. Help with date ranges - Hi all, I'd like to know if anyone can help me with a good suggestion on how to achieve this. I have... Help with basic stored proc, two part name giving me grief. - Hello, I have the following basic sp to truncate a table... Create Procedure sp_Truncate_Address @DBName varchar(30) = , @TableName varchar(30) = . @SQL = 'TRUNCATE TABLE' + @DatabaseName + ' ' + @TableName EXEC... Partitioning to Address Resource Contention - HI. I'm new to partitioning so please bear with some naive questions. We have a large application that does daily pricing... Trying to speed up this 'GetWorkingDays' function. - I'm trying to redesign one of our working days functions. The idea is to calculate weekends (easy enough) but holidays... Convert list of columns into quoted, comma delimited list of columns - Summary: I've got a working solution(s). My question is, which is the best approach (if any)? Details: I want to write... Identify wrong links inside a hierarchical tree-structure - Hello, I'm working on an electrical network, edge are link between nodes, insert lines with 'end' are all clients. The first line... How to loop through two tables data and fine matched ones using loop - Good Morning, Create table #tablesrc (VendorId int, vendorname varchar(30), brokerfee int, aliancedate datetime, active bit, matchedstatus bit) Create table #tabletarget (VendorId int,... using cross apply to find different values trough xml files eficiency - Hello Experts, I am trying to run the following query: SELECT CAST(t.nodes.query('data(item)') as varchar(max)) 'Item', CAST(t.nodes.query('data(bp_orno)') as varchar( SQL memory Performance counters review and help - Hi All, Need your help to understand that my DB server is require more memory or not as per the below... SQL versus program - Hi all, I'm posting my question in this 2008 forum because we're running SQLServer 2008R2, but it is more a general... How to logout from SSMS 2016 (Microsoft SQL Server)? - I've implemented the Always Encryption to encrypt the SSN field for a Patient table in my Azure DB.(Using Azure Key... |
|
| 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 |
|
|
