Security is a complex process, one that is becoming more and more important to DBAs all the time. This week Steve Jones wants to know how security is handled for your service accounts.
2016-08-29 (first published: 2012-08-10)
259 reads
The Database Engine on the Data Platform departs for Linux. A late arrival but worthwhile, says Phil Factor.
2016-08-29
57 reads
2016-08-26
79 reads
The Australian Census was a mess, and supposedly some university students build a better version. Steve Jones comments on better coding practices.
2016-08-25
123 reads
Today Steve Jones talks about the job changes and prospects for those that manage IT systems.
2016-08-24
199 reads
No matter what we do to secure our databases, we need to be sure our applications are well written, both with secure coding, but also good information handling.
2016-08-23
108 reads
Many of us would like to be sure we could rollback changes made during a deployment if they caused issues. Steve Jones notes that it might not be worth actually building those scripts in advance.
2016-08-22
484 reads
2016-08-22
90 reads
A smoke test can be a good way to ensure complex systems are working as expected after maintenance or changes.
2016-08-19
935 reads
The way that governments build software and work with data must change if we want to be more efficient.
2016-08-18
56 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
i have subscription of github copilot which i can access in vs 2022 comunity...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item 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