Encryption Keys Matter
Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.
2016-09-13
70 reads
Editorials
Ignoring Database Version Control
Steve Jones thinks version control is important, even for databases.
2016-09-12
144 reads
Teaching a dog to sing
To survive the inevitable downturns in the IT industry, Phil Factor argues that a IT manager needs to take time to maintain technical skills. It is not enough to understand development; you have to be able to do it.
2016-09-12
96 reads
Impressive Accomplishments
What things impress you most about potential candidates. This week Steve Jones asks the question to try and understand what types of activities data professionals might consider.
2016-09-09 (first published: 2013-02-15)
256 reads
Practicing Deployments
Amateurs practice until they can get something right. Professionals practice until they don't get things wrong. How should we handle our deployments?
2016-09-07 (first published: 2013-02-12)
379 reads
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)
2016-09-05 (first published: 2008-03-12)
287 reads
Towards a Single Management Stack
Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.
2016-09-05
61 reads
The Copy Cat Poll
This poll asks about copies, specifically those of your databases. How many do you keep around? How much extra storage does this cost? Steve Jones thinks that most organizations have quite a few copies, which can use a lot of resources.
2016-09-02 (first published: 2012-08-03)
177 reads
Time Off
Finding a balance between work and life away from work is hard, but one good way is with periodic vacations. Today Steve Jones notes that some people don't take their vacation, which he sees as a problem.
2016-09-01 (first published: 2012-08-20)
250 reads
Avoiding Stored Procedures
This week Steve Jones argues against stored procedures. Is it a good argument or do want to stick with your stored procedures.
2016-08-30 (first published: 2012-08-13)
1,072 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers