Certifications: What are they good for?
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
616 reads
- Interests: cooking, F1 grand prix, internet, mobile apps
SQL SERVER 2012 - How to get a value from previous result row effectively
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
692 reads
70-457 Reviewer #12, Restoring SQL Server Databases
This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam....
2013-09-08
697 reads
70-457 Reviewer #11 Configuring and Maintaining a Backup Strategy
This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...
2013-09-01
536 reads
70-457 Reviewer #10 Managing SQL Server Agent
This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables...
2013-08-31
1,205 reads
Using DMV to identify sessions in your SQL Server
More than running sp_who2, which gives you more information than the good ol’ sp_who, or querying sys.dm_exec_sessions to check all...
2013-08-24
806 reads
Who’s doing what to your SQL Server?
When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to...
2013-08-24
662 reads
Get the Backup History in your Central Management Server for SQL Server
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
695 reads
70-457 Reviewer #09, Auditing SQL Server 2012
This review topic is still covered under the Optimize and Troubleshoot SQL Server lesson which covers 14% of the exam....
2013-08-13
581 reads
Deploying your SSIS Packages in SQL Server 2008
Prior to building and deploying your SSIS project to the SQL SSIS server, you need to build and create a...
2013-08-02
888 reads
Blogs
Github Copilot in SSMS can include data in its memory, simple prompt injections ahead
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Forums
Don't Create Workslop
Comments posted to this topic are about the item Don't Create Workslop
What is the original database name?
Comments posted to this topic are about the item What is the original database...
The DBScan algorithm tutorial
Comments posted to this topic are about the item The DBScan algorithm tutorial
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers