Denali – Day 27: System Center Advisor (aka ‘Atlanta’)
Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis...
2012-05-27
1,009 reads
Vinay Thakur
Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)
Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent) If you are good with: Xls Pivot table Power...
2012-05-26
1,071 reads
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
MDS and Best Practice Analyzer new features were introduced in sql...
2012-05-25
704 reads
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Earlier sql server was having diagnoses tool.
Default trace.
SQLDiag
And other tools but could not...
2012-05-24
1,429 reads
Denali – Day 23: Data Quality Services (DQS)
Denali – Day 23: Data Quality Services(DQS)
Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data...
2012-05-23
1,460 reads
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
As stated earlier on blog on “LocalDB” discussion, developers are involved...
2012-05-22
905 reads
Denali – Day 21: Security
Denali – Day 21: Security
Security wise Microsoft sql server is going great and on compare with other RDBMS in the market...
2012-05-21
780 reads
Denali – Day 20: More Programmability Feature
Denali – Day 20: More Programmability Feature
Native XML Web Services (SOAP/HTTP endpoints) is Removed:
Earlier version of sql server support Web services...
2012-05-20
933 reads
Denali – Day 19: Programmability Feature -T-Sql
Denali – Day 19: Programmability Feature -T-Sql
ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):
OFFSET is a location of the rows...
2012-05-19
1,025 reads
Denali – Day 18: Engine: Express LocalDB–Command line
Denali – Day 18: Engine: Express LocalDB–Command line
Express LocalDB is an express edition with minimum files required to start sql server...
2012-05-18
1,963 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers