SQLSaturday#71 is only a day away! - Final Schedule....
Just a final note for all of you planning on attending tomorrow's SQL Saturday #71 event extravaganza up in Boston. The event...
2011-04-01
756 reads
Robert Pearl
SQL Server Quiz - Answer the questions, win a prize.....
It's March Madness, and we're not just talking about basketball. We're not just talking about Women's History Month, which is...
2011-03-15
2,104 reads
SQLSaturday#69 - Philadelphia Wrap-Up
Just wanted to take the opportunity to summarize my experience at SQLSaturday#69 in Philadelphia, this past Saturday. Another city, another amazing event! I haven't been...
2011-03-08
2,373 reads
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Sometimes, folks come to me, and ask for...
2011-03-04
5,043 reads
SQLSaturday#69 - Update - Schedule Posted! - You Can Still Register
It's just a little less than 2 weeks to SQLSaturday#69 at DeVry University, 1140 Virginia Drive, Ft. Washington, PA 19034...
2011-02-21
870 reads
Intro to SSAS BI Workshop - Review
A Synopsis of My Experiences of the “Intro to SSAS” BI Workshop in NYC!
By Robert Pearl
Well it’s a wrap of...
2011-02-18
1,841 reads
What's OLD in SQL Server 11 aka Denali? - Deprecated Feature List
Well, we always see, hear, and read about the list of NEW features in the myriad of articles, columns and blogs...
2011-02-08
1,732 reads
28-days in February - What to do - Read about Waits & Queues
Happy Monday! I'm sure many of you may have already caught on, that Waits & Queues is the way to go...
2011-02-07
712 reads
Microsoft SQL Server Licensing For Dummies..
Don’t let the above title fool you! Have you been confused on the Microsoft SQL Server Licensing requirements? Per Processor, Per CAL, Per Core, Per Socket, Per Node – Per haps (space intended :-), we should revisit the issue again, and try to offer some assistance as you go forward in making your purchasing decisions.
2011-02-04
4,848 reads
Something BIG in Boston - SQLSaturday#71
BIG in BOSTON
Last time, I blogged about the first upcoming event in the North East in Philadelphia, PA – SQLSaturday#69, but...
2011-02-02
634 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers