I will be speaking at PowerShell Conference Asia 2017
Which better way could I have to launch my blog if not with great news ?!
I am so happy and excited to announce that I will be speaking at PowerShell...
2017-08-25
Cláudio Silva
“Does that copy subscriptions too?” – Now it does! New PowerShell SSRS commands
On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the...
2017-08-15 (first published: 2017-07-27)
5,186 reads
SSRS Report Deployment Made Easy – 700 times Faster
Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server...
2017-07-12
3,919 reads
Have you backed up your SQL Logins today?
Why am I asking?
Have you never have been in a situation where:
the master backup is corruptedyou need to rollback a password...
2017-06-22
406 reads
It is possible to run scripts inside SSMS on multiple instances without using CMS? Yes, it is!
Today I will write about an option that is less known/used in the SSMS tool. The ‘SQLCMD Mode’ option.
What is...
2017-02-14
3,508 reads
Analysis of DBA professionals salary’s 2017 using PowerBI
On the 5th of January, Brent Ozar (b|t) launched a survey on “Tell Us What You Make: The 2017 Data Professional...
2017-01-23
396 reads
Find and fix SQL Server databases with empty owner property using dbatools PowerShell module
A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”....
2017-01-19
1,021 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers