| A community of more than 1,600,000 database professionals and growing |
| | | Provisioning This editorial was originally published on May 24, 2013. It is being re-run as Steve is on holiday. At a talk recently, the presenter talked about the time lag for an on-premises server to be installed and configured to be on the order of months. Not that many, but it could easily be six months. That seems crazy, but in many companies I've worked in, that wasn't an unusual time frame. From the time someone decided that a purchase was allowed, it could be days for the accounting department to approve the funds. A day or two to place an order, assuming that IT had already provided the specifications. Vendors respond quickly, but it could still take a week or two, possibly even more, for a server to arrive at our company. One of the advantages of cloud computing services is that new virtual machines can be bought and enabled in minutes. That might be true, but I wanted to ask many of you if you know how longs it actually takes for you to begin working on a new SQL Server. How long does it take to provision a new server? Imagine that you were to ask for a database server today, and you management agreed to grant the approval, think about how long would it be before you could sign into a SQL Server. I'm sure some of you have virtual infrastructures available, and that should reduce the time it takes, but let us know if that's your setup and how long it takes. The ultimate service would be a cloud like application inside your organization that allowed you to select a SQL Server template, and send you a server name and login with minutes after an automated build took place. I don't know many companies that have that yet, but I think many of us would appreciate that capability. Especially if we could choose the hardware we required. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | DLM Demo Webinar Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now. |
| | | | 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. |
| | | | How can you help your team write better, shareable SQL faster? Find out by discovering 15 Super SQL Tips from Microsoft MVPs and other SQL Server experts. Using SQL Prompt to write, refactor, and share SQL, they show how it strips away the repetition of coding and standardizes it everywhere. View the tips and download a free trial. |
|
|
|
| | | | | David Klee from SQLServerCentral.com In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware. More » |
| | Additional Articles from SimpleTalk Windows hasn't had a package manager in the style of the Advanced Packaging Tool (APT) of Linux distributions. Apt-get is a great way of installing packages and other software. We have Chocolatey, of course which has a growing library of software and even allows you to automatically update software. Now PowerShell has an 'official' way of using any system, such as NuGet, Chocolatey, GitHub or PSget. It is definitely useful and likely to mature into an indispensable tool for Windows users. Nicolas explains wh. More » |
| | Grant Fritchey from SQLServerCentral Blogs Tired from all those blog posts For my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a... More » |
|
|
| | | Today's Question (by Steve Jones): Which port does the SQL Server Browser service communicate on? |
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: Browser Service. 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 | | Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2 - With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this Preview 2 ebook, we introduce three new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TempDB configuration, query store, and Stretch Database, and more. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| 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 service pack,hotfix applied dates - Hello, Found Powershell script in below blog to list the last install date and time for windows updates on servers. https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca Is there... how to restore 12 gb backup file it on sqlserver 2012 - I have 12.5 GB database backup file.i want to restore it on SQL Server 2012 ,when i m restore database... Compare subset with subset in same table - I have a table with 2 columns, FormulaID, IngredientID The table contains formulanames with the ingredients. I want to find formula pairs... Help with delimited SQL - Hi Guys, I am trying to execute an array of comma delimited SQLs in a stored procedure. I call it as below... Day-On-Day / Month-On-Month Queries for Temporal Tables - Thanks in advance for any tips on this: I'm looking for some documentation on how to form queries that track changes... How to troubleshoot sudden drop in Page Life Expectancy? - We have a monitoring tool, which is Solarwind DPA, that shows sudden drop of P.L.E. at different times. For example... Windowing function with conditions? - Hi, I have the table below: [code="sql"]CREATE TABLE [dbo].[ATABLE]( [EVENT_ID] [int] NOT NULL, [EVENT_RANK] [int] NULL, [MIN_AGE] [float] NULL, [MAX_AGE] [float] NULL ) ON [PRIMARY] GO INSERT [dbo].[ATABLE] ([EVENT_ID],... Query help filling in dates and data - I have a data table and a calendar table. I need to fill in the gaps to have a row... Overlapping datetime ranges. - Overlap in ranges. I have a set of data,rows which a start_time and a end_time. Each row should get a New_starttime, so... GROUP BY in SQL Server 2014 - Hello all, The same query with a group by clause I try to run on SQL Server 2005 and on SQl... 824 error and some DB inconsistencies - Hi I am looking for some expertise to point me in the right direction. Last night one of application databases... Replication Error - URGENT - Getting error on replication, log reader agent: Log reader fails with “The process could not execute ‘sp_replcmds’ on <DB01> ” error Needs to... Help with Query to Look at the list and return repeated value if condition is met - Hi Everyone I asked a similar question in my previous post but didn't get the right result , although it is nearly... Script to find which active transaction is using more space in tempdb - Hello, Can someone help me with script of finding transactions which are heavily using temdb space in their queries. Thanks in advance Parsing paired relationships. - Hmmm... OK, I can do this but only with some really expensive RBAR table operations, the script I've written takes... Stored Procedure execution - Hi, Below is the scenario. [code="sql"] CREATE PROCEDURE SP_MAIN AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT... Loading CSV files into SQL Server Database tables - Does any one know of an open source tool that I can use to load data from csv files into... RAID recomendations - I'm starting to study for my Admin MCITP for 2008 and the first thing I have been hitting is the... Why Shouldn't I use Linked server? - Hello Everyone, I have 4 SQL database servers (all using SQL Server) and need to communicate between them for lookup... Error 208: Invalid object name ''msdb.dbo.MSdistpublishers'' - Hi Guys, We have a server setup as a distribution server, which manages the replication to & from 3 other SQL servers. Last... |
|
| 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 |
|
|
