70-457 Reviewer #06, Configuring and Managing Database in SQL Server 2012
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
644 reads
- Interests: cooking, F1 grand prix, internet, mobile apps
Understanding Contained Database in SQL Server 2012
SQL Server 2012 supports contained databases and partially contained databases, which provide a high degree of isolation from the database...
2013-07-24
1,233 reads
70-457 Reviewer #05, Configuring SQL Server 2012 Components
The lessons covered for this review is Configure Analysis Services Configure and Deploy Reporting Services Configure and Deploy Sharepoint Integration...
2013-07-22
564 reads
70-457 Reviewer #04, Implement a Migration Strategy
Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012....
2013-07-18
581 reads
70-457 Reviewer #03, Planning an Installation of SQL Server 2012
Planning an installation on SQL Server 2012 is under the Install and Configure SQL Server objective which is 19% of...
2013-07-16
649 reads
Check unused index in SQL Sever 2008
Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for...
2013-07-15
357 reads
2013-07-14
289 reads
MSSQLTIPS SQL Server Webcast
MSSQLTIPS offers new webcast monthly. Topics in various areas of SQL Server are covered and perfect for all DBAs out...
2013-07-12
412 reads
Access denied on your SSIS SQL Server 2008
Scenario. You have a new SSIS server. All DTS packages migrated and deployed successfully to this new SSIS server. You send...
2013-07-11
335 reads
SQL Server Diagnostic Information Queries for July 2013
Reblogged from Glenn Berry's SQL Server Performance: I have gone through and made some minor updates and bug fixes for...
2013-07-11
350 reads
Blogs
Friday Flyway Tips–Flyway Parameters
By Steve Jones
Flyway is a command line tool with lots of options and parameters. Working with...
A New Word:Wildred
By Steve Jones
wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in...
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Forums
Query goes crazy.
Hi. I have a query that returns few rows (out of 7 table join,...
Migration from Sybase SAP SQL Anywhere to SQL Server 2022
By Stewart "Arturius" Campbell
We are working on a project to migrate a client from a version of...
How to Setup Backups and Restore planning in SQL Server Availability Groups?
I need some help regarding How to Setup Backups and Restore planning in SQL...
Ask SSC