GOTO and T-SQL
Today we have a guest editorial from Phil Factor as Steve is on vacation. This piece looks at the complaints against GOTO and whether they are valid.
2011-12-22
889 reads
Today we have a guest editorial from Phil Factor as Steve is on vacation. This piece looks at the complaints against GOTO and whether they are valid.
2011-12-22
889 reads
Today we have a guest editorial from Andy Warren. Andy talks about the relationship with your boss, and how you ought to view them as your customer.
2011-12-21
232 reads
When an employee has pride in their company, they tend to do a better job, and Steve Jones says that extends to security.
2011-12-20
121 reads
SQLServerCentral will be hosting a track at the 2012 spring SQL Server Connections conference and we hope to see you there.
2011-12-19
66 reads
Today we have a guest editorial from Andy Warren. This one follows on from his "are you easy to work with" piece.
2011-12-16
290 reads
Do you connect to your work network with your smartphone? If so, you should be careful and ensure you are taking precautions to prevent any security issues.
2011-12-15
209 reads
If you would like to tackle an interesting project at work or find yourself something new to do next year, read this idea from Steve Jones.
2011-12-14
391 reads
Instagram has a complex architecture for it's technology infrastructure. The people that work there have to be jacks of all trades. Is that the type of environment you'd like to work in?
2011-12-13
160 reads
With the amount of data being stored expanding exponentially, does the role of the DBA need to change from caretaker to interpreter?
2011-12-12
262 reads
Encryption is supposed to protect data, and it appears to be working as police and authorities are often stymied by encrypted disks. Steve Jones recommends you encrypt your disks on all your machines.
2011-12-12
367 reads
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
Wa:628218200233 Alamat. Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers