ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?
2016-05-05
3,586 reads
In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.
2016-05-04
2,058 reads
Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.
2016-05-04
3,767 reads
Ability to enable Instant File Initialization during the installation of SQL Server 2016.
2016-05-03
1,407 reads
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?
2016-05-03
5,701 reads
2016-05-02
115 reads
Your SQL Agent Jobs may be silently failing when using Linked Servers.
2016-05-02
2,833 reads
This week Steve Jones recommends installing Cumulative Updates. If you can test them.
2016-05-02
98 reads
Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.
2016-05-02
3,466 reads
Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!
2016-04-29 (first published: 2014-12-30)
13,027 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Title pretty much says it. I want to join to a table that has...
Comments posted to this topic are about the item Building a SQL Server Fleet...
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers