Selecting a menu structure from a series of tables is pretty easy. If you bound the number of levels in the menu. However if you have potentially variable numbers of levels. Stephen Lasham brings us a new piece on using recursion to select the data.
One thing Access developers love about using SQL Server as the back end is that it is easy to do maintenance. I can't tell you how many times I toured around an office, looking for users who had their client open and connected to the data so I could ask them to log out. Too many times, the offender was at lunch or away from their desks, with their desktops locked.
Auditing is becoming more and more important in many SQL Server environments. DBAs are being tasked with setting up, maintaining, and reporting on audit data. Author Leo Peysakhovich brings us one of his solutions to automatically generate an audit trail for your data.
There have been quite a few impressions of the PASS conference from our blogs, but here's another from Haidong "Alex" Ji, oneo f our longtime authors and a guest of SQLServerCentral.com at the Summit.
How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.
If a hacker sets sights on your SQL Server, there are four primary methods he can use to take control and carry out unauthorized, malicious activity. I will look at each of these: Password compromise, Account compromise, SQL injection, Buffer overflows
It just ended, but Chris Hedgate filed a report from the airplane as he sped home at 30,000ft across the Atlantic.
Steve Jones takes a moment to talk about the SQLServerCentral.com reception at the Summit last week. And a few pictures as well. Whether you were there or not, see what you missed and what you can look forward to next year.
That certainly is a mouthful, but it boils down to author Michael Coles implementation of a sound matching search for SQL Server 2005. Another mouthful, but if you are interested in getting close matches because your clients cannot spell, you might want to read this one.
Throughout this and other of my series, we have examined parameterization and parameter picklist support. While my focus has often been support of picklists using datasets generated through MDX queries against the cube under consideration, I have often found myself in client engagement scenarios where differing reporting requirements, as well as various "exceptions," drive a need to extend picklist support beyond the capabilities of the basic MDX queries that we have examined.
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Telp/Wa 628218200203 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok...
Telp/Wa 628218200233 Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, Banten 42112
How many types of DML triggers are there?
See possible answers