SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,351 reads
Synchronization
How to Synchronize Two SSAS Servers
Unfortunately SQL Server Analysis Services (SSAS) does not support differential backups and creating full backups for the servers might take too much time. In this tip we are going to show how to synchronize two SSAS servers in order to have a failover server in case something goes wrong with one of the servers.
2013-05-14
3,409 reads
RE: Multiple User Logins??
Yes it was set in Single User mode Problem is, I do not have the rights to change it myself, and the tech support people do not seem to understand my problem.
2004-02-20
RE: Queries for complete DB schema?
Frank,Thanks for the info. It's a good starting point although I'm trying to build something that is a lot more comprehensive. ThanksBen
2004-02-05
RE: Simple query help
Don't use the table names in the select list:CREATE VIEW IMEXtrlrUtilUNIONasapSM_VW as SELECT top 100 percent OrderNbr, City, Shipper, Weight from IMEXtrlrUtilShipMat_VW Union select top 100 percent OrderNbr, City, Shipper, Weight from IMEXtrlrUtilASAP_VW ORDER BY OrderNbr, City, Shipper For the record, even if not including and Order By clause, I advocate never using Select * […]
2004-01-20
RE: Article exceeded 255 # of col in trans repl
Thank you very much MarkusB! I thought may be there are ways around.... If not, ok tough luck
2003-06-30
Blogs
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...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
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