 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | The Five Year Plan This editorial was originally published on June 13, 2013. It is being re-run today as Steve is traveling. IT departments won't exist in five years. A bold prediction from the CITE conference last week. It's not so much a prediction of an increase in cloud services, but more the idea that the centralized IT department is struggling with the consumerization of technology, the increasing demands of the business for faster turnaround on projects and prototypes, and the flexibility being demanded by an increasingly technology savvy workforce. Like most predictions, I take this one with a grain of salt. I don't think five years is enough time to change the face of the enterprise IT groups. Five years ago the first iPhone had been out for a year and was being demanded by users to replace their Blackberries. These days many corporations support iPhones, along with other smartphones, and Blackberries have disappeared from many organizations. However IT has adapted, released some of their control, and even integrated some of their policies into new technologies. When I enabled corporate mail on my smartphone recently, I had to allow some remote management features to get mail, which was fine with me. I do agree that we will start to see some of our IT functions, especially small projects and POC (proof of concepts) increasingly being driven in departments. There are too many projects, too many different technologies, and too little time to work on them for central IT departments to tackle all these projects. Departmental management won't wait for IT that is stretched too thin, especially if they have existing staff that have some technology skills. That latter factor is something becoming more and more common all the time. However I can't see central IT disappearing. There are often quite a few systems that are complex, that are too large, too important to let someone manage part time. There are projects that cross departments, or even the entire company, and coordinating tasks and resources between departments is complex. Add to all of this the problems and hassles of hiring good technology people, and I can see projects rising in departments, but being turned over at times to IT to manage. I do think that central IT groups need to be more flexible, and reduce some of their rules, or adapt them to new technologies and platforms. I expect people working in central staff to be "lent" to departments for projects, perhaps even multiple departments at the same time to help get projects completed, while also gaining some training on the various systems in order to provide support when other staff isn't available. Such as weekends. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | 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. |
|  | | SQL in the City Streamed Register now for Redgate's free virtual event offering a wealth of SQL Server sessions for you to livestream on December 14 and 15. Find out more and register. |
|  | | SQL Clone – create database copies fast! Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Download the beta. |
|
|
|
| | |  | Gemma Bibby from SQLServerCentral.com Learn how to add a sparkline and line chart to your SQL Server 2014 Reporting Services reports. More » |
 | Additional Articles from SimpleTalk There are so many ways of keeping your technical skills and knowledge up-to-date. There are books, articles, conferences, video courses and so on, but nothing beats discussion and debate with professional people in other organisations facing a similar range of technical challenges, some of which you share, and others you maybe haven't yet. PASS is unique in providing just this vital ingredient for database professionals using the Microsoft Data Stack. More » |
 | Learn how to use Redgate’s DLM solution to improve your database change management process in our free webinar on December 13th. Microsoft Data Platform MVP, Grant Fritchey, and Redgate’s Arneh Eskandari, will demonstrate how Redgate’s tools plug into TFS, TFS Build & Microsoft Release Management so that you can build, test and deploy your database alongside your application code. More » |
 | Arun Sirpal from SQLServerCentral Blogs When you have many SQL databases that are required to run your environments and they show signs of specific usage... More » |
| | Summary: If databases in secondary replica are out of sync with primary then below is the workaround which helps to... More » |
|
|
| | | Today's Question (by Steve Jones): How can I get the version of PowerShell I'm using from a PowerShell command prompt? |
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: PowerShell. 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 | | Expert T-SQL Window Functions in SQL Server Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | Eric Russell from SQLServerCentral.com A column level check constraint may be used to prevent insertion of data containing characters within a specific ASCII range. In the supplied example, we are preventing insertion of data containing character within the range of char(0) - char(31). For example, it will reject data containing embedded tabs {9}, carriage returns {13}, or line feeds {0}. It is reccomended that you provide the constraint with a descriptive name, because it will assist users with identifying the source of the error. Here is the result of inserting data containing a trailing tab. insert into MySample ( col1 ) values ('John'+char(9)); Msg 547, Level 16, State 0, Line 20 The INSERT statement conflicted with the CHECK constraint "cc_col1_InvalidData". The conflict occurred in database "master", table "dbo.MySample", column 'col1'. 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.
datbase error - [url=http://nationbuilder.com/panthersvschargerslivestreamingnflweek14] Panthers vs Chargers Live Streaming[/url] SQL Server 2016 and Raspberry Pi - Hi everyone, I am starting work on a Project that will use an application on the Raspberry Pi3 to connect to... Disk space full - Hello everyone, I have a server setup where my data files sits on d drive(currently which is full) My tempdb,logfiles and backups... Unable to restore a database on a new instance - [b]Scenario[/b] Moving database from: Microsoft SQL Server 2008 (SP4) - 10.0.6241.0 (X64) Apr 17 2015 10:56:08 Copyright (c) 1988-2008 Microsoft Corporation Enterprise...
the time mamro rioe eormeormeormemrkelr - [url=http://billsvssteelers.us/]Bills vs Steelers[/url] [url=http://billsvssteelers.us/]Bills vs Steelers Live[/url] [url=http://billsvssteelers.us/]Bills vs Steelers Live Stream[/url] [url=http://steelersvs-bills.us/]Steelers vs Bills[/url] [url=http://steelersvs-bills.us/]Steelers vs Bills Live[/url] [url=http://steelersvs-bills.us/]Steelers vs Bills Live Stream[/url] [url=http:/ yet it is a substance, and something undesirable - yet it is a substance, and something undesirable, by the idea – supplements ought to, however much as could be expected.... The to a great degree successful cancer prevention agent elements - On the off chance that despite everything you get mistook for the execute execution of the things there is nothing... the most fundamental thing is masterminding - the most fundamental thing is masterminding, so you decidedly should get an action journal, and in addition eating diary where... Stored Procedure help - I wrongly posted this in SQL Server 2005 so re-posting here as I couldn't move it. I'm running SQL Server... Backing up log in High Availability - Hi, I am backing up the transaction log via a maintenance plan every 15 minutes on my secondary high avail server....
supplementation, for event, the degrees of the comprehended - supplementation, for event, the degrees of the comprehended Yohmbe other than L-Arginine HCL, Maca Root, and Horny Goat Weed, which... Let the optimizer do it's thing -- wrong - I've heard this advice everywhere. Don't do things to change the way the sql optimizer produces plans etc. "it's smart... Is it right way to add filtered column as main column for creating filtered index - Hi I have a query like below. table contains 70 million records select MIN(createtime) _time_ from tablename where status <> 20 and...
Converting time - from "seconds after midnight" - Hello all, We have time saved in our db in a seconds after midnight format and need to convert it to...
Sports have been increasingly organised - [url=https://www.europafietsers.nl/sites/default/files/webform/routeopmerkingen/espn-eagles-vs-redskins-live-stream-american-football-nfl-cast-lincoln-financial-field-14th-week-11-dec-2016.pdf]Eagles vs Redskins Live Streaming[/url] Print file names - what is command to print current ldf and mdf file names used by all respective databases in my SQL Server... I'm scared to delete log file - Hi, I have two files i.e [b] .ldf[/b] and [b].mdf[/b] in my disk. As we know these are normally SQL Server... Find all dates between date ranges in a table; Prefer tally table solution - I suspect there is both a CTE and a tally table solution here but I would prefer the tally solution Given...
McMullin: 'Trump is not a loyal American' - [url=https://www.youtube.com/watch?v=ee0rt_GzjVU]Washington Redskins vs Philadelphia Eagles Live Streaming[/url] [url=https://www.youtube.com/watch?v=uv7gGP9lZsI]Arizona Cardinals vs Miami Dolphins Live Streaming[/url] [url=https://www.youtube.com/watch?v=rNHdFZeTqDU]Chargers vs Panthers Live Streaming[/url] [url=https://www.youtube.com/watch?v=cit2uB5GFF4]Bears vs Lions Live...
Cannot Detach/Attach SSAS Database to move to Another Server - We have a new server and want to move the SSAS databases from the old server to the new one.... |
|
| 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 |
|
|