In today's database reporting market, most vendor applications use a proprietary format for representing the definition of a report. In addition, vendors that provide a report execution environment usually only support their own design tools. For customers, this means that reports cannot be easily moved between different reporting implementations and that there are few options for choosing new tools that work with their existing execution environments.
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition, focusing in particular on security-related topics. This article continues this subject by describing other technologies that assist with data protection, their corresponding configuration settings, and a few authentication and authorization caveat
MDX applies "bankers' rounding" algorithm in its ROUND() function. This article shows you how to avoid that and round like in T-SQL and Excel.
We should get help from vendors, as well as support, but what about innovation? Today's guest editorial from Brad McGeHee asks if the third party tool vendors for SQL Server are doing enough to provide value for the cost of their tools.
Take this survey from the SQL Server developer team at Microsoft.
Because installing SQL Server is so easy it is tempting to cut corners, fail to plan properly and blindly accept default options without considering the alternatives.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Jl. Raya Mangga Besar No.15, RT.6/RW.5, Mangga Besar, Kec. Taman Sari, Kota Jakarta Barat,...
Jl. Jelambar Baru Raya No.53 C, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
MENARA BCA d/a GRAND INDONESIA, Tlp:085373737845.Jl. MH Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers