Using Azure Machine Learning with an on-premises Database
With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning...
2017-05-24 (first published: 2017-05-14)
4,030 reads
Data Warehousing Explained
Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...
2017-05-14
302 reads
Quick Graph Database
There’s a sample to work through here: https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-sample
I decided to try this in CTP2 and just see how it works....
2017-05-12
1,215 reads
Speaking at Charleston PASS on May 18, 2017
During the day of the 18th I’ll be at the Syntax Code and Craft Conference in Charleston, SC. That evening...
2017-05-12
329 reads
Microsoft Build event announcements
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in...
2017-05-12
664 reads
Friday Reading 2017-05-12
The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been...
2017-05-12
398 reads
SQL Server on Linux Series: Why?
As you all have heard, Microsoft is supporting Linux as a supported operating system for the next version of SQL...
2017-05-11
768 reads
DevOps Basics–Creating a local repo and committing files
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-05-11
592 reads
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
13 reads
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
60 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers