The idea of ‘instrumenting’ an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers and profilers that developers seem to resent the idea that applications should be designed and developed so as to be measurable. Tony Davis looks at the issue.
2015-08-18
4,712 reads
2015-08-17
4,210 reads
MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.
2015-08-17
2,032 reads
When the different teams that are involved throughout the life of a database fail to reconcile their different roles and priorities, and so fail to cooperate or work adaptively, the result is gridlock: databases defined as though carved in stone rather than by code and data. William Brewer explores how DLM can offer an alternative that allows databases to respond quickly to business change.
2015-08-13
7,221 reads
Don't underestimate the ERRORLOG. There is some great information in it for you to use not just when you're troubleshooting performance or investigating errors, but also when you're proactively monitoring an instance. Erin Stellato explains.
2015-08-12
3,517 reads
Part 2, a more in depth look at An alternative approach to disaster recovery and backup strategies using PolyBase.
2015-08-11
2,101 reads
With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 or later Enterprise Edition with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional costs. In this article series Arshad Ali will demonstrate how you can use Datazen for creating dashboards and KPIs (Key Performance Indicators) for mobile devices easily and quickly.
2015-08-11
5,810 reads
2015-08-10
2,163 reads
It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Robert Sheldon takes stock with the Simple BI Timeline which explains how BI has evolved over the years.
2015-08-10
4,879 reads
2015-08-07 (first published: 2012-06-20)
15,752 reads
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Most embedding pipelines on AWS have the same shape: a job reads rows out...
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
WA CS (08218154392) Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
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