The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.
Today Steve Jones discusses the need to hire the people to do the tasks we need done, not the position we filled.
In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode
The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.
Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database.
Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.
The issue of copyright for online scripts is a grey area. If a script is published without any form of copyright notice, most people assume that it is freely available for reuse. It's not necessarily the case.
Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.
Koen Verbeeck provides an overview of the new features and capabilities found in SQL Server Reporting Services 2016.
In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers