Wildcard Searches (SQLServerCentral 2/10/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Wildcard Searches]( - [Query Performance Tuning – A Methodical Approach]( - [Reconciling Data Across Systems Using a Reconciliation Hub]( - [Data masking survey and prize draw]( - [Using Extended Events in Azure]( (From the SQLServerCentral Blogs) - [SQL Containers and Networking]( (From the SQLServerCentral Blogs) The Voice of the DBA Moving Through Five Years I wrote the [Five Year Plan]( in mid 2013. In it, I noted there was a prediction that [IT departments wouldn't exist in 5 years](, meaning in mid 2018. That's a year and a half away. Is that a possibility? I don't think so. The more I work in the technology world, the more I see a need for humans to help manage the systems and data. The systems are complex, the small details of getting a platform up and running are varied and not standardized across any two companies, and I can't envision a complete self-service world. As easy as the Azure or AWS consoles can be, the mindset of those platforms still expects a technical person to choose options and provision systems. After all, how many of your non-technical friends understand what geo-redundancy is? It doesn't seem that IT departments are really shrinking. As I look through various surveys, employment statistics and predictions, it seems that most all positions in IT are still growing and hiring. The outlook for the next few years is still good and the pay is still rising overall. What does that mean for all the DevOps, self service, and BYOD vendor support that hint at less jobs for many administrators? I suspect that there are trends at some companies, where mundane, less skilled, easy-to-automate jobs are being replaced by automation. Some companies may even eliminate certain jobs, like the Database Administrator, but they don't really eliminate people. Those individuals that can learn to handle other work, and become more efficient still keep their jobs, albeit with different titles. Some work may get handled by systems, but much of the work just gets distributed to other staff as a part of their jobs. I've seen this in software development at companies that eliminated testers. Developers and operations staff start to become responsible for different aspects of testing. Each person spends a little time testing, in addition to their other work. Everyone ends up doing a little less of what they used to to, but a little more of something new. This also usually results in a larger development staff to cover the work the testers used to do. Often this means the department remains the same size, some testers become junior developers, and we've moved work around. The shared responsibility might actually improve overall quality since the impact of poor code gets noticed by more people. I think this is what will happen with many operational IT staffs. Perhaps some companies will try to eliminate the IT department, but really just move the staff to different departments, changing the reporting structure, perhaps expand some of the responsibilities of people, but they'll likely still have the same number of "IT staff", even if they don't call it that. This doesn't mean that each of us should count on gainful employment at our organization until we retire. Most of us should constantly get better at our jobs, and learn more about technology. I would recommend you learn new skills, but constantly and regularly practice and polish your old ones. Become better at your craft, even as you might choose to grow your career in new ways. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( --------------------------------------------------------------- The Voice of the DBA Podcast Listen to the [MP3 Audio]( ( MB) podcast or subscribe to the feed at [iTunes]( and [Libsyn](. [feed]( 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 [SQL Source Control]( 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.]( Featured Contents  [] [Wildcard Searches]( Luis Cazares from [SQLServerCentral.com]( Using wildcard to find patterns in strings going from the basics to some more complicated conditions.[More »]( ---------------------------------------------------------------  [] [Query Performance Tuning – A Methodical Approach]( Gail Shaw from [SQLServerCentral.com]( Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.[More »]( ---------------------------------------------------------------  [] [Reconciling Data Across Systems Using a Reconciliation Hub]( Additional Articles from [SimpleTalk]( In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancies in data must be detected, tracked and corrected as quickly as possible: there is no room for error in doing this. A Reconciliation Hub can provide the answer, as Rahul Gupta explains.[More »]( ---------------------------------------------------------------  [] [Data masking survey and prize draw]( The Foundry team at Redgate know that managing sensitive and regulated data can be both challenging and problematic. They want to solve these problems, but first need your help to better understand them in context. What do you find frustrating? What would save you time? Please fill out this short survey to let them know, and as a thanks for your time, at the end you'll be entered into a draw to win a $100 Amazon gift card.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Using Extended Events in Azure]( Arun Sirpal from [SQLServerCentral Blogs]( Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace,...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [SQL Containers and Networking]( Andrew Pruski from [SQLServerCentral Blogs]( I recently talked with the guys over at SQL Data Partners on their podcast about SQL Server and containers. It...[More »]( Question of the Day Today's Question (by Steve Jones): Why does DBCC in SQL Server 2016 run faster by default? 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: DBCC. 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 [Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1501026526) Take advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools. [Get your copy from Amazon today]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1501026526). tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1501026526 Yesterday's Question of the Day Yesterday's Question (by Aaron Nelson): When using the Get-SqlDatabase cmdlet, if you want it to exclude system databases when it returns, how do you filter that down? Get-SqlDatabase -ServerInstance localhost Answer: Pipe to Where-Object IsSystemObject -EQ $false Explanation: The answer is fairly straightforward, just get the list of databases and filter them using the Where-Object cmdlet (note that you can call the Where-Object cmdlet by just saying WHERE). Get-SqlDatabase -ServerInstance localhost | WHERE IsSystemObject -EQ $false How would you find a field like IsSystemObject to filter on in the first place? Start with a call to the Get-SqlDatabase cmdlet and ask for a system database, like master. Then pipe the results to SELECT * and have a look at the properties for one that you can use. Get-SqlDatabase -ServerInstance localhost -Name master | SELECT * Ref: Get-SQLDatabase - [( --------------------------------------------------------------- [» 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](. --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Hardening SQL Server]( - Hello everyone! Does anyone here hardening project of sql server? What major parts of this project and what is your recommendation? If you... [Re-installing a SQL Server Instance]( - Hi, I have a need to completely uninstall and re-install SQL Server from several servers but I'd like to preserve as... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Query works until I use it in a stored procedure (contains forward slash)]( - I've tried escaping the '/' forward slash in various ways I found by googling my problem but nothing is working so... [Connection problem from SQL Server 2016 to SQL Server 2008 R2 using SSIS]( - I have a SQL Server 2016 SSIS project that works just fine against SQL Server 2008, 2012, 2014, and 2016... [Interview Question]( - Hi. Recently I have attended a couple of interviews. I have faced a similar question about stored procedures. What are... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Performance improves after reboot]( - This happens the third time in the last 6 weeks. Sql Server performance gradually deteriorates during 2 weeks period. We reboot the... [TDE after restoring to a Different Instance]( - Hi Experts, I have a TDE enabled database and i successfully restored it to another instance of SQL after restoring the... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [trouble wit a poor performing query]( - I've got a poor performing query and not sure the best approach to fixing it. Here's the statement: UPDATE @t  SET... [Delete the duplicate records of table having only one column]( - Hi all, Kindly suggest  or  share  such query to  me , How we can delete the rows having duplicate records Condition; Table having... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Every day count of Inventory]( - Hi, we have an Inventory Transactional Fact Table, which provides count of inventory according to particular product. like [How to write a string to a file in SQL.]( - Hello All, I want to write a varchar(max) string to a file. The file should be UTF-8 (and not in a multi... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Count Difference for Every 15 Min]( - Hi, When I run the query using mulitple joins on Fact table and Dimension Table, my Output would look like Execution :1 When... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Need quick help with query optimization]( - Hello, We have one query which is running frequently through out the day. I have attached SP and execution plan for... [High Memory Usage]( - In our production server , memory usage is around 95% even tho it has been capped (8 GB ) . Total memory 12... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [How to declare and pass a variable inside the SQL String when using Stored Procedure.]( - SP variable should be available inside the @Query String. See comment section. SP works but doesn't return anything since it... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server Newbies]( [convert month name to month number]( - Hi All How should i convert the month name to month number like 'April' it should converted to 4 'January' it should converted... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Performance Tuning]( [Reclaiming space after dropping index]( - Hi All, I've identifying duplicate index on one of the database using this query. WITH indexcols AS (SELECT object_id AS id,     ... --------------------------------------------------------------- [Reporting Services]( : [SSRS 2016]( [Migrating Subscriptions and Schedules from SSRS 2008]( - Hi My company currently runs SSRS 2008 in production, and we've stood up an SSRS 2016 server and are in the... --------------------------------------------------------------- [SQL Server 2005]( : [Development]( [Store result in Variable of dynamic query]( - hi declare @lstr varchar(200) declare @word varchar(20) set @lstr = 'select top 1 name from sysobjects' set @word = exec(@lstr) select @word i want ot store... --------------------------------------------------------------- [SQL Server 2005]( : [T-SQL (SS2K5)]( [Split Row into Multiple Rows]( - Hi, I'm trying to split a row of data based around the quantity in the row. For example, if there is... This email has been sent to {EMAIL}. 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