 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | SQL Server on Linux Years ago I wrote an April Fools story about SQL Server running on Linux. For years, this was one of the most popular referrals at SQLServerCentral from Google as many people apparently wanted to get SQL Server on Linux. Well, my joke is now reality. On the official Microsoft blog, there was an announcement of SQL Server running on Linux in preview last week. Apparently substantial work has been done in this area if there's a preview available, with an aim to release a product in mid-2017. That's somewhat amazing, and I'm very curious about this in two different ways. One is how they technically made this work. With different threading and schedulers, this is fascinating from a technical perspective.This makes me wonder how much porting work was done, and will continue to be, necessary. Will there be issues keeping the Linux version up to date with the Windows one? However I also wonder what the business model is. Are there that many people who want to, or would, run SQL Server that don't want a Windows OS? I know that the people managing the OS might see SQL Server as just another database application, but I haven't run into many places that would refuse to install Windows. Maybe this capitalizes on the Azure Data Lake work on Ubuntu? Or the desire to integrate SQL Server more tightly with Hadoop/HDInsight, many installs of which run on Linux? I suspect there are groups more comfortable with Linux and the LAMP stack than Windows, and this gives them the chance to use the incredible SQL Server platform on the OS they are comfortable with. This is exciting as a SQL Server professional, giving us more potential opportunities for employment and new challenges for the platform. I expect to see SQL Server continue to grow and prosper as one of the premier relational database platforms in the world. As we move to a more cloud based, hosted model for our software, having our platform be independent of the OS is, I think, a good thing. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.0MB) podcast or subscribe to the feed at iTunes and LibSyn.  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 |  | | Get the advantages of ALM for your database Reduce risk, speed deployments, deliver value fast. Database Lifecycle Management brings the advantages of source control, continuous integration, and release management to your database. See how with this free whitepaper. |
|  | | What do Git migrations, fast performance, and support for TFS 2015 & SQL Server 2016 have in common? They’re all just a few highlights from the SQL Source Control roadmap, due over Christmas and in the next year. To find out what else is in store, check the roadmap now. |
|  | | SQL Prompt v7 now supports Visual Studio 2015 as well as SSMS 2016 It also lets you create your own placeholders in snippets, open an actions list when you select text in a query, use different tab colors, and find more invalid objects. Find out how. Find out how. |
|
|
|
| | |  | Steve Jones from SQLServerCentral.com Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+. More » |
 | Additional Articles from SQLPerformance.com Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload. More » |
 | Press Release from PASS Virtual Chapter meeting, Mar 16, 12pm EST. Documentation is mostly overlooked and only comes up when a problem arises. What if you'd have a tool or method to generate documentation for all your database servers? In this session, Sander Stad will show you show how easy it is to use PowerShell to retrieve information from your servers. He'll detail what can be used to document your servers, how to retrieve the information and what should be documented. In the end you no longer have an excuse not to document your servers. More » |
 | Andy Galbraith from SQLServerCentral Blogs I had an incident today where a colleague was running a Wait Stats Report and the output looked like this: As... More » |
| | AnupWarrier from SQLServerCentral Blogs A strange error struck me last week, and this post is all about that. What you normally expect when you run... More » |
|
|
| | | Today's Question (by Steve Jones): Why should you not set ANSI_NULLS to OFF? |
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 | SQL Server Internals: In-Memory OLTP: Inside the SQL Server 2014 Hekaton Engine The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is designed from the ground up to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided. Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SSMS, but Hekaton's internal behavior and capabilities are very different than those of the standard relational engine. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I am looking to write a script that performs an action based on the database collation. How should I structure my IF statement inside the parenthesis? IF () = 'SQL_Latin1_General_CP1_CI_AS' BEGIN -- do some work END
Answer: DATABASEPROPERTYEX(db_name(),'Collation') Explanation: Since collation at the database level can be different from what is set at the server level, we need to use the DATABASEPROPERTYEX() function to get the database collation. Ref: DATABASEPROPERTYEX() - https://msdn.microsoft.com/en-us/library/ms186823.aspx
» Discuss this question and answer on the forums |
|
|
| | | Haden Kingsland (theflyingdba) from SQLServerCentral.com restore_databases_to_another_instance_sp_generic should be created within the source instance of the database that is being backed up and restored. It needs to be created in conjunction with the kill_users_other_than_system_sp procedure in Part 1, which should be created within the destination instance for the restore. The process relies on a pre-seeded backup having been restored to the destination from the source, so that subsequent backups can be overwritten at regular, scheduled intervals using the SQL Agent. You will need to create a linked server within the source instance, that links, with the appropriate permissions to the source instance, so that the kill sproc can be run remotely before the restore is initiated across the network. An example linked server creation script can be found here... ---- Linked server : --sp_addlinkedserver '','SQL Server' --go --sp_addlinkedsrvlogin '','false',null,'','' --go --sp_serveroption '','collation compatible','off' --go --sp_serveroption '','data access','on' --go --sp_serveroption '','rpc','on' --go --sp_serveroption '','rpc out','on' --go --sp_serveroption '','use remote collation','on' --go --sp_serveroption '','collation name',null --go --sp_serveroption '','connect timeout',0 --go --sp_serveroption '','query timeout','7200' --go ... the name that you give this linked server MUST be referenced in the restore_databases_to_another_instance_sp_generic sproc on the source instance, and so is currently denoted in the attached script as []! 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.
Update Trigger - Keep Old value unchanged for a column - using UPDATED and DELETED temp tables, how can I override the new value and keep the old value for a... Preparation a Database for Developer team - Hi Professionals We have a schadule task that I have to 1- Backtup of main database 2-Update Critical data 3-Delete Old...
2 SQL Tracefiles on startup - Hi Guys I have 2 trace jobs running on start up 1 is the defailt trace file, the other tracefile I cannot... Access Granted for : CREATE USER [Domain1\UserName] FOR LOGIN [Domain1\UserName] - Hi All I have a question about the User Access for a Database. My Scenario is as below I have a database... using converted var char date time field to return records in a date - I have date and time stored in the following format: mm-dd-yyyy hh:mm:ss I only need the date part, and want to... Dealing with large tables (Financial transactions) - Hi, We have in our production database a large table that is storing financial transactions, currently the table has about 90mlns... Cannot drop the table 'TABLE' because at least part of the table resides on an offline filegroup. - Hello all, I am checking to see if this is even something that can be done. I have a non-prod db that... Bit of a "Newbie" question. Compare and join databases. - Hello all, greetings from a cold-winter Sweden. I have a problem that i need help with, tried to seach the forum...
Find difference between two records - I need to keep history for each record in my table. I created another same structured table with action field... t-sql 2012 sort order - In t-sql 2012, I have the following select statement currently; SELECT PERNUM , RTRIM(LASTNAME) + ', ' + RTRIM(FIRSTNAME) + CASE WHEN MIDDLENAME IS NULL THEN... Copy some data from one table to another - Hello, I have two existing tables: Table 1 and Table2. Both tables have some data. So I want to copy some data from... BCP text file is adding an extra line at the end of the file - I am using a BCP statement to output file to text so it can be uploaded to another application. However...
subtracting a case statement result from a Convert(char(8) result - Hello, I am struggling to get a case statement result to be subtracted from another result in the same format.I want... Split Multiple Times - Hello I have a simple problem, that i can solve easily with help of cursors, but i want to know if... LIKE with 2 searches - I need to find all items that end with B and S. Not sure what I am doing wrong, if I... Move to new row - I'm having issue to move data to new row for my txt output. sample data resultA resultB resultC resultD chicago ID123 20pax ID123 austria...
Changing data type to optimize performance - Hi All, I have read many articles recommending use of varchar instead on nvarchar as first one only reserves the amount...
Parent and child relationship is broken when do the sort based on parent name - Hi All, I want to sort the name based on 1st level (sort only applicable root id is null or...
PowerBI Desktop - CALENDAR() function - I have a working PBIX file that looks at symptom data over time, and I was trying to do the...
Potential presentation idea: The role of documentation in disaster recovery - I seem to be coming up with a lot of presentation ideas that have to do with documentation and tech... |
|
| 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 |
|
|
