Windows Firewall is an OS level software firewall. It can be a crucial part of OS level security if you are not using other firewall hardware or software. Since I do not have another firewall I have a need to enable Windows Firewall for my SQL Server database server. In this article I go through the process of configuring Windows Firewall for different scenarios along with the associated considerations.
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
We have recently made a few changes in our newsletter sending process and been working with Yahoo to ensure delivery. If you are just receiving this newsletter to a Yahoo account, welcome.
Steve Jones recently went on a search for a new laptop, looking for the "best" one for him. But what it the best? And is it worth pursuing?
Do your system contain a time bomb in the code? David Poole looks at some potential situations where you might be experiencing performance issues and delves into why.
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.
Is it a problem for SQL Server to have a backdoor that lets a Windows Administrator connect as a sysadmin? Steve Jones thinks so and gives a reason why this might be a problem.
Get a feel for this book from
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Semantic Search in SQL Server...
Comments posted to this topic are about the item Encoding URLs
Comments posted to this topic are about the item An SSIS Upgrade
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers