 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | A Joke Come True Yesterday was the opening of Microsoft Connect 2016. If you didn't have the chance to watch the opening keynote, I'd recommend you do so. Mostly because one of my jokes, or perhaps a dream, has come true. SQL Server runs on Linux, and you now run it yourself. I know Microsoft has talked about this for most of 2016, and they have used it in demos, but there haven't been public bits available. I've been lucky. In fact, I've been running SQL Server on Ubuntu since April of this year as part of a private program. I've been testing various Redgate Software tools as well as my demo code from presentations and so far everything has run. This includes the tSQLt framework and my tests that make use of SQLCLR. This includes my AlwaysEncrypted demos. I was very impressed that these features just worked, as though this instance were any other SQL Server that I had installed. What's more, the installation and updating of SQL Server on Ubuntu, using apt-get, is far, far smoother than the installation on Windows. To be fair, this is a default installation, and I haven't tried to set up all the various options and settings that are available on Windows. The various additional subsystems (SSIS, SSAS, SSRS, etc) aren't available as well, but still, it's a very smooth process. As I've updated various release candidates across the last few months, I run two commands: "apt-get update", and "apt-get install mssql-server". I don't know if this is a good business decision for Microsoft. Time will tell, but I can't help but think that the addition of another platform on which SQL Server can run is good for the product. More people will consider SQL Server as their database platform, with all of the powerful features and capabilities that brings to a database driven application. I suspect this will mean that many developers working in non-Microsoft environments with Linux, Java, PHP, and more will begin to consider SQL Server as an alternative to PostgreSQL and MySQL, in addition to Oracle and DB2. Certainly there is still a cost to using SQL Server, but it's an incredibly powerful platform, one that now has a more consistent programming surface since almost all features are now available in Standard as well as Enterprise with SQL Server 2016 SP1. Getting RLS, Columnstore Indexes, In-Memory OLTP tables and more in all additions is a major win, and another of the pet peeves I've wanted changed for years. I am very interested to see how people view these changes, and if they will impact you? Do you want to run SQL Server on Linux? Since In-Memory OLTP and other features are now on Standard, are you interested in upgrading to SQL Server 2016 now? Perhaps you're a little more excited about Microsoft and SQL Server with all of the new development changes announced yesterday? Let me know today. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | Get the advantages of DevOps 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. |
|  | | Not enough hours in your day? The SQL Toolbelt lets you reduce the time spent on SQL Server development and administration. Cambridge University developer David Spaxman, for example, says: “I’m saving 10-12 hours a week using the SQL Toolbelt.” Learn how you can double your productivity, speed up deployments and protect your data. Download a free trial. |
|  | | 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. |
|
|
|
| | |
 | Additional Articles from MSSQLTips.com Receiving an access denied error message when trying to connect to a remote instance of SSIS from SSMS? Sadequl Hussain provides the solution. More » |
 | What is Residual Predicate? Lets say one gets a query to fine tune. While checking the execution plan, if there is... More » |
| | Chris Taylor from SQLServerCentral Blogs We all know that if you want SQL Server to push data into a table then you want to batch the... More » |
|
|
| | | Today's Question (by Steve Jones): I've built a small table to test some searches and added a little data: CREATE TABLE MyData ( mychar VARCHAR(50) ); GO INSERT dbo.MyData (mychar) VALUES ('This is a string'), ('"A Quoted String"'), ('''Single quoted string'''), ('''more single quotes'''), ('[My bracketed string]'), ('[I like brackets]'), ('[Can I find this string]') ; GO Now I want to query and find the rows that begin with a bracket. Which query should I use? |
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 2 points 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 | | Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud 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 ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database Get your copy from Amazon today. |  e |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Sergiy): I create a temp table and a table variable with identical structure. Then I populate them within a transaction: DECLARE @Table TABLE ( col1 VARCHAR(50) ) CREATE TABLE #Table ( col1 VARCHAR(50) ) BEGIN TRANSACTION INSERT INTO @Table ( col1 ) SELECT 'Value' INSERT INTO #Table ( col1 ) SELECT 'Value' ROLLBACK TRANSACTION What would be content of both tables after rolling back the transaction?
Answer: Only @Table contains 1 record Explanation: Table variables, as well as any other kind of variables, are not affected by transaction rollback. Temp tables behave in transactions the same way as static user tables. Ref: Table - https://msdn.microsoft.com/en-us/library/ms175010.aspx
» Discuss this question and answer on the forums |
|
|
| | | Hannan Kravitz from SQLServerCentral.com You can either use the function as a simple select statement such as SELECT * FROM [dbo].[INSTR] ('Hello World','l',1,1) in addition you can use at in cross /outer apply clause select t.* , f.Loc from <table> as t CROSS APPLY dbo.INSTR (T.<Column>, <strToSearch> , <StartPosition> , <Occurance#>) f 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.
how to find the users who deleted the records from the sql table - Hi Sir, how to find the users who deleted the records from the sql table? do we have SQL script for this... Stupid question? How to exclude 'SA' using sp_who - Hello, I am not acutally a beginner, but a simple task like filtering users seems to be a daunting task... SSMS 2016 slow connection (Windows 10) - After upgrading from Windows 7 to Windows 10 - and after some updates of windows a very slow connection (10 - 20s)...
Help with a query runs forever but returns nothing. - Ok the WHERE clause is a Unique index. If I run the SELECT / FROM / JOIN's I get data returned no... Newbie here... Wishing to learn SQL and SSIS/SSRS/SSAS - Hi all, A newbie here wishing to ask for advice on Microsoft Business Intelligence. Hoping this is the right forum to...
Access is denied - Hi chaps, 1st post here, so be gentle with me :-) Got a bit of an odd one here that I'm scratching... Benefits of SQL 2014/2016 over 2005 ?? - I'm sure it's a long list, but what are the "Top 10" list of improvements I can take to management...
Query - I have a truantday table that has students who has absent, each row is one student, one truant day starting...
Computed Column in optimizing query returning large data - Hi, I have the following query that is returning 1.6 M rows and about 300 columns. I can't change this factor.... Difference bw Update & Delete/Insert, in terms of fragmentation - Hi guys, I was looking into the differences when we issue an update vs delete/insert. Below is my setup and observation I... is it possible to determine the max length of a field in a csv file? - This has been discussed before but I couldn't find a case/answer that might apply to my situation: From time to time...
Replace uppercase words with bold - I need to replace in given string all uppercase strings longer than two characters with lowercase and set html bold... Update duplicate keys - So I have a stored proc INSERT INTO dbo.Table2 (Application, Timestamp, Performance, Availability) SELECT Application, CAST(Timestamp AS DATE) as Date, AVG(CAST(Performance AS decimal(6,2))) as...
SQL Query/JOB Error - Hi all, Need advise for my error Executed as user: NT AUTHORITY\NETWORK SERVICE. Arithmetic overflow error converting IDENTITY to data type int....
Passing Parameters in SSRS - I am trying to pass a parameter from one report to another. I will be passing a YYYYMM from one... 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...
Multiple Joins on Fact Table - Hi, I am building a DW which will load data from 2 separate sources. Each source will populate the Broker Dim table...
Database Mail process shutting down - Hi Everyone I'm setting up maintenance jobs to backup data and to notify me. The Database mail service starts when I...
Find all queries which use a perticular index. - If i want to delete my IX_Unused_Index but before that i want to identify which queries will be affected if...
How can automate report from sqlserver to be sent on email everyday. - Hello! Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i... |
|
| 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 |
|
|
