| A community of more than 1,600,000 database professionals and growing |
| | | SOS I've been using various tools to work with SQL Server for a few decades. I was comfortable with Query Analyzer and a variety of tools in SQL Server 4.2, but quickly warmed up to Enterprise Manager in SQL Server 6. When Management Studio came along, I was a bit dismayed, and briefly turned to a few third party tools to manage my servers and run queries. However, SSMS improved over the years, and much of the tool has become second nature for me. At the PASS Summit recently, Microsoft unveiled the SQL Operations Studio. This is the next iteration of SQL Server tooling, based on the project Carbon. This is a fork of VS Code, and it feels very VS Code-ish. I have been playing with various builds for quite a few months, alternately pleased with the progress and annoyed by things that don't work like SSMS. Perhaps the lack of ALT+X/CTRL+E to execute queries is the big one, but overall the look and feel are odd for me. Maybe I'm too used to SSMS, but I didn't feel that some of the other SQL editors felt odd. VS Code does at times, and this carries into SOS. The public availability of the product in preview was released Wednesday at Microsoft's Connect event. It's cross platform, so OSX and Linux users and use it from their systems. I'd urge you to give it a try and see what you think. Perhaps many of you will like the tool more than I will and it will grow and succeed. I've already seen some blogs this week that discuss the IDE and I expect to see more over time. SOS. That's a funny acronym, at least to me. Is there a subliminal message that this will save us? Or maybe that we'll need saving with yet another tool to take this one's place? I have no idea, but I'm surprised that marketing came up with this but I suspect like many marketing people, they assume everyone will use the name, not the acronym. You'd think marketing people would learn that acronyms matter. I've seen this referred to as MSOS, but I'm not sure that will catch on. I still think it's got a funny name, but it's not the worse one out there. I'm sure a few of you can think of other acronyms that didn't do their product, or the developers that should be proud of their work, any favors. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | Database migrations inside Visual Studio Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free |
| | | | Have you got NoSQL fingers? No, thought not. Writing and tuning queries in JSON is a short-cut to repetitive strain injury. But with Studio 3T - the IDE for MongoDB - you can manage MongoDB directly with SQL queries. Join the accuracy of SQL to the speed of NoSQL. Get me my free 14-day trial. Get a free 14-day trial |
|
|
|
| | | | | Andy Jones from SQLServerCentral.com Script provided to create missing extended properties allowing you to auto generate your database documentation. More » |
| | If corruption creeps into a database it can and will derail the best-laid disaster recovery plans. To be certain that a database is corruption-free, you need to run regular DBCC CHECKDB checks on that database. Unfortunately this is a resource-intensive task, but SQL Clone can help. More » |
| | Additional Articles from SimpleTalk There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL Server within AWS as a simple database service, much like a more versatile alternative to MySQL. Obviously, it is a compromise, in that you lose many of the extras beyond the database. Laerte Junior answers those questions about RDS that people seem to assume you know the answers to, but which you may be too shy to ask. More » |
| | Dharmendra Keshari from SQLServerCentral Blogs If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,... More » |
| | Brian Kelley from SQLServerCentral Blogs I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking... More » |
|
|
| | | Today's Question (by Steve Jones): In SQL Server 2016, I want to add a custom message. In testing as a serveradmin, I run this code. What happens? EXEC sys.sp_addmessage @msgnum = 50000, @severity = 10, @msgtext = N'This is the lowest custom error message', @lang = 'us_english', @with_log = 'TRUE' |
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: SYS.MESSAGES. 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 | | Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | Konstantin Taranov from SQLServerCentral.com -- For table with Identity Column ID with SET IDENTITY_INSERT ON @useIdentity = 1 and KEEPIDENTITY property EXECUTE [dbo].[usp_BulkUpload] @path = N'd:\', @databaseName = N'DatabaseName', @tableName = N'TableName', @useIdentity = 1, @debug = 0; -- For table with Identity Column ID without SET IDENTITY_INSERT ON @useIdentity = 2 EXECUTE [dbo].[usp_BulkUpload] @path = N'd:\', @databaseName = N'DatabaseName', @tableName = N'TableName', @useIdentity = 2, @debug = O; -- For table without Identity Column @useIdentity = 0 EXECUTE [dbo].[usp_BulkUpload] @path = N'd:\', @databaseName = N'DatabaseName', @tableName = N'TableName', @useIdentity = 0, @debug = 0; 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. Is it preferred to keep the SQL server Min memory to 0 (default)? - Hi Seeking expert opinion to know what is the preferred option / value for SQL Server Min Memory? Implications of slower writes with 64K pages using SSDs vs SAN - As part of our migration to SQL Server 2017, we are considering a move to local SSDs. Some testing with... Installation issues on Windows Server 2016 - Hi. I'm hoping this is an easy fix for somebody as I've spent a while on this today. I'm trying... sum case issues with commas and dashes - ,SUM Indexing Issue - Hi, I have the following temp table listed below. In the interface we created the user has the option to enter in... Creating partition on SQL Server 2016 standard edition - I have created a partition on a table which is close to 170 GB in size. Since I have never... The File stream database xxxx is not accessible. (ObjectExplorer) - Hi Every one, I am facing a critical issue. like One of our File stream Database in not accessible in MS... GRANT UNMASK ON SCHEMA? - Is there a way to grant UNMASK privileges to a user at a schema level? My use case is this: There... Help with open rowset error - I have a SQL server 2016 sp1 sitting on a windows 2016 standard 64 bit, and I am trying to... Trying to convert a int @variable to a varchar @variable with leading zero. - I am trying to create a text variable called @varnumber with a leading zero for values less that 10. Below... What is the best ways of storing unstructured data in sql server 2016, except filestream. - What is the best ways of storing unstructured data in sql server 2016, except filestream. Add only changed or new rows to table - Hi I am a DBA who does a small bit of SSIS / TSQL development and have been given a project... Incrementing integer values within closed quotation marks and parentheses in VBA for SQL - I have to add incrementing integer values within closed quotation marks and parentheses. Question 1. How can I increment the... Stranger security problem - We recently migrated a 2008 sql server to a 2012 server using 2012 windows. Now when I select the properties of a... Combine rows by applying grouping and data validation - Hello All, I have master data, based on that i am trying to prepare query in such way that rows can... SSRS : Order the appearance on the chart according to the values of one of the fields - Dear all, I am creating a new SSRS report. This report as a chart. Chart dispalys execution time and number of executions. Problem... Querying specific values in column that's using XML data - Boy, I've been researching this subject, but I am just not getting it. Sorry if I'm asking a question that... Installation of Reporting services on separate machine - Hi, Thanks to everyone contributing to the solutions here. Here is the scenario: I have fresh DW setup going on. We have 1... T-SQL Statement Task not running when scheduled - I had the same issue when just pasting in syntax as a SQL job where it runs the syntax as... Hard going back... - Is it just me, or once you've used SQL Server, is using Access again (especially for reasonably complex queries) just... |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
