| A community of more than 1,600,000 database professionals and growing |
| | | Developer Deployment Frustrations This editorial was originally published on Sept 7, 2012. It is being re-published as Steve is at DevConnections. Why don't developers like SQL Server? Probably a few reasons, but I'm sure this is one that really frustrates them. I found a Connect Item that was titled: Why is Deploying SQL Server 2008 R2 sooooo FRUSTRATING?!! There really is a question there, asking for guidance on which versions of SQL Server are available and recommended for developers to include in their applications. When SQL Server MSDE was released, it seemed that Microsoft was looking for it to be included in small applications that might then be upsized to a Standard or Enterprise edition of SQL Server. It seems to me that this is really the market for Express (the evolution of MSDE) and that it ought to be simple for a developer to not only deploy this with their application, but also setup basic maintenance easily. I sometimes think that the software developers at Microsoft get lost in their own specialty and forget just how frustrating it can be for the rest of us trying to use their product in new ways. They forget that many of us want to deploy simple solutions easily, and not spend a lot of time working out the nuances of software setup. I'd like to see Express not only have a very simple setup that works across multiple versions of Visual Studio, but also baic maintenance plans built in that allow full and log backups (if needed), along with index rebuilds with a simple switch set as a part of setup. A few registry keys or XML config changes could set paths or frequencies. Making life simpler for developers is a worthwhile investment for the SQL Server team. It makes them more likely to include it in their applications. If you can add a one-switch replication to sync to a Standard or Enterprise SQL Server, they might think Express is required in every application. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | 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. |
| | | | Could you deploy a high number of databases? Imagine working in a 70-strong IT team, with 91 applications and multiple complex databases. Now imagine deployment time. It's not fiction, it's fact. See how financial services company, FlexiGroup, has brought speed and precision to database deployments. Read their story. |
| | | | Find SQL in your database for free For example, want to rename one of your table columns but are not sure what stored procedures reference it? Using Redgate’s free SSMS add-in, SQL Search, you can search for the column name and find all the stored procedures that use it. Find out more and download now. |
|
|
|
| | | | | Andy Warren from SQLServerCentral.com Many of have applications that log errors to a table. Ever thought about what happens when an application starts to throw a lot of errors? This article looks at the problem and some of the responses you might consider having ready in case it happens to you! More » |
| | Additional Articles from SimpleTalk For some time now, C# programmers have gazed enviously at the interactive capabilities of F#, Python and PowerShell. For rapid prototyping work and interactive debugging, dynamic languages are hard to beat. C# Interactive slipped into view quietly, without razzmatazz, in Visual Studio 2015 Update 1. It's good, it's worth knowing about; and Tom Fischer is intent on convincing you of that. More » |
| | Arun Sirpal from SQLServerCentral Blogs When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that... More » |
| | Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Stream Graph chart Power BI Custom Visual. The Stream Graph... More » |
|
|
| | | Today's Question (by Steve Jones): What happens if you run this code? CREATE TABLE MyNewTable ( id INT , firstname VARCHAR(200) , lastname VARCHAR(200) , ) |
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 | | Professional Microsoft SQL Server 2014 Integration Services The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | S M from SQLServerCentral.com DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script. Copy the script onto SQL Server Management Studio Run it. Copy the string from cmd column and run it. Do not run all the shrink against all databases together. You need to review properly before you run the script as this is just for the purpose of assisting other DBAs. If any performance issue occurs I may not be able to guide. 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. Sql Server 2016 Installation Issue - Hi All, when i trying to install sql server 2016.iso file i am getting below error . Please give me solution for... conditional where clause - I have this problem I cannot solve. In a stored procedure I need to make a select query. A parameter... Kerberos issues and Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - We have a linked server set up. It will connect with no problem, but it seems that we periodically are... Msg 3013, Level 16, State 1, Line 2 BACKUP DATABASE is terminating abnormally. - [code="sql"]BACKUP DATABASE [Staging] TO DISK = N'\\NetworkStorageLocation\ProjectA\Test_backup_2015_04_24_105955_2107357.bak' WITH NOFORMAT, NOINIT, NAME = N'Test_backup_2015_04_24_105955_2107357', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO [/code] Error Message that i... Which of the 2 queries is better in terms of performance - select c.custid,c.companyname from sales.MyCustomers c left join sales.MyOrders o on c.custid=o.custid where o.orderid is null Or select custid,companyname from sales.MyCustomers where custid not... CONVERT DATETIME to TIME and remove seconds and milliseconds - Hello Folks, How can I convert StartTime2 so that it equals StartTime1 DECLARE @StartTime1 TIME SET @StartTime1 = '17:41:00.0000000' SELECT @StartTime1 DECLARE @StartTime2 DATETIME SET @StartTime2 = '2016-09-22... SSIS Package Foreach Loop Container not finding files when deployed (fine in DEV) - Hi there, I have a SSIS 2014 package using the Project Deployment model and parameters. I have a project parameter called... How do you import a JSON file to SQL sever - These commands below were copies directly from a website. I changed the path. SELECT BulkColumn INTO #temp FROM OPENROWSET (BULK 'C:\Users\moody\Desktop\api.json',... Largest insert delete transaction query - Hi All, How to find the size of Largest insert,delete, update transaction? SQL Server Setup - I have installed yesterday SQL server 2012 SP1 with update enabled for SP2 on a 4 node cluster. Now i want... Extract a uniform pattern from a file path - Hi All I have a strange problem here which I can't quite get to the bottom of. I have a file path... "Add" Hyphen Data Modification - Hello, First time poster on this forum. I've recently been thrown into the world of SQL server, so my experience is... t-sql 2012 cursor - In a t-sql 2012 listed below, I want the lockids to be set individually from 117173 to 117678. The problem... sql query to display a trailer record at the end in txt file (using batch file) - hello, I want to display a trailer record at the end of records : the spec is as follows Trailer Record: Field Name Length Begin ... How To DISTINCT COUNT with Windows Functions (i.e. OVER and PARTITION BY) - SQL 2012 Reference = http://msdn.microsoft.com/en-us/library/ms175997(v=sql.110).aspx I'm trying to get a unique count of rows in a child table in a multi-table join... Select Distinct and sum - Hi there i am trying to output just 2 columns WITH THE RESULTS COLUMN A COLUMN B HOUSE NAME TOTALS HOUSE A... Calculate time difference between two related visitors without using cursor - I have a table (see attached) listing visitors IDs, listed more than once, and Arrival DateTime. I need to find... Calculate dynamic columns - Hello team, On Sql Server Report Builder, I'de like to know how to calculate dynamic columns or how to deal with... Star Schema Design - Multiple Sources - Hi, I am planning the design of a star schema for a data warehouse. The data will be loaded from 2... MDX Calculated Measures not affected by slicers - Hi! I'm new with this howl MDX thing and cant seem to figure out how to make the following work. I... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|
