Backups in Azure SQL Data Warehouse
This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.
2017-03-20
3,069 reads
recover
RE: Problem with CAST
Or you can eliminate the CASE altogether and do something like thisSELECT 'ST_GR' = RIGHT('0' + CONVERT(varchar(2),ST.GR),2)
2005-01-19
RE: Date Ranges
From reading your post it looks like you want to know guests who will be in the hotel for at least one day between 8/1/05 and 8/10/05. It also looks like it doesn't matter when they will be checking out. Try the following query:Select <ColumnList> From <Table> Where ArrDate Between '08/01/05' and '08/10/05'
2005-01-04
RE: Cant drop user - Help!!
It is because this user does not exist in this server. First of all the user must have a login that exists. You can create one if you are a sysadmin. Then you have to associate the login with the database user, because at this point it is an orphan and SQL Server does not […]
2004-06-22
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers