Quickly Restricting Database Access
There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed. You want to stop users from connecting right away, but …
Would you like to see Redgate tools inside SQL Operations Studio?
You may already have heard about Microsoft’s new DevOps platform for database development, SQL Operations Studio. Related to this, Redgate is doing some research into cross-platform data tools. Read this blog post to find out more about what they …
Level 1: An Introduction to Row-Level Security
Learn the basics of how Row-Level Security works in SQL Server.
SQL SERVER – Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It
While trying to create linked server, sometimes there are errors. One of the error is below which is related to TCP Provider. The linked server has been created but failed a connection test. Do you want to keep the linked server? TCP Provider: No conne …
2017: the year in books
Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016) and people have been enjoying it, so here I present the …
What has happened in the DAX world in 2017
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2017/12/27/what-has-happened-in-the-dax-world-in-2017/
Our 25 Most-Read and Most-Commented Blog Posts of 2017
We published a whopping 312 blog posts in 2017! Looking back, wow, there was a lot of fun stuff in here. First, here’s the ones you read the most: 25. Max Worker Threads – Don’t Touch That 24. Announcing Our 2017 Black Friday D …
Free eBook: Understanding SQL Server Concurrency
When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.
Current State of the NewSQL/NoSQL Cloud Arena
Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you …
SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005
While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error. TITLE: Maintenance Plan Wizard Progress —————— …
How to Move from a ‘90s Workplace to a Digital Workplace
Sponsored by: SoftwareONE /VMware
CISO Perspective: How using the NIST Cyber Security Framework improves security visibility
Sponsored by: AlienVault
How to Manage Today's Roaming Users: Removing Complexity from Identity Management
Sponsored by: Imanami
Next Christmas, How About Some Cybersecurity?
An ITPro Today writer says she doesn’t need anything next Christmas, but it would be nice if she can hold on to what she already has.
Public Cloud Vendors Found Unlikely Partners in 2017
Public cloud vendors like AWS and Google partnered with data center juggernauts in 2017 to bring enterprises to the cloud.