70-457 Reviewer #08, Implementing Clustered Instance in SQL Server 2012
This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17%...
2013-08-01
619 reads
- Interests: cooking, F1 grand prix, internet, mobile apps
Amazon Partners With Cloud vLab To Teach Developers How To Use AWS
Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that...
2013-07-31
1,367 reads
How secure is your IT career? Really?
I was reading some articles from my favorite influencers in LinkedIn and I came across this one. I was enlightened...
2013-07-30
1,222 reads
Using MSX and TSX to scale out your maintenance plans
For our front office alone, I manage about 15-20 SQL database servers. Add to that other database servers that I...
2013-07-30
1,329 reads
Free Ebooks! Free Ebooks!
There’s a lot to smile on a cool Monday like this. One, it’s 27C outside here in Singapore, a lot...
2013-07-29
694 reads
SQL Server Management Studio Rainbow Edition
Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management...
2013-07-29
680 reads
What I’m sayin’ is…everything is fine.
Let’s say you are a member of the development team. Your team got a new project in the works, so...
2013-07-29
628 reads
Go ahead. Laugh.
I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one...
2013-07-27
528 reads
Rebuilding server level collation setting
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,815 reads
70-457 Reviewer #07, Resolving Concurrency Problems in SQL Server 2012
This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall...
2013-07-25
1,833 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
ASCII value of certain column is null
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Need to output table data into multiple CSV files
Hello, I created the below script to output 999 rows from SQL Server table...
Changing Database page Verify on a Database in an AG
I have a database on SQL 2019 in an Availability Group (AG) and I...
Ask SSC