SQL Saturday #203 - Boston
Join us at SQL Saturday Boston on April 6th. SQL Saturday is a free training event for SQL Server Professionals and those wanting to learn more about SQL Server.
Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions
n a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles?
Google Glass Your Database
A new idea from a small startup may revolutionize the way that you search for data.
NoSQL: Are you ready to compromise with security
Before adopting NoSQL for a commercial application that needs consistency and durability, you need to be satisfied that the product actually provides all those niceties that the user of relational database systems take for granted.
Throttle a Query in Mid-Execution
Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.
Mo-SQL
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.
TSQL Pivot Rotations using only REPLACE
Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOT, here is a way to do it using only REPLACE.
Adding Rows in Incremental Loads - Level 3 of the Stairway to Integration Services
Learn how to incrementally load new rows into a database from an Integration Services package. MVP and SSIS guru Andy Leonard continues his series on learning SSIS.
SQL Saturday #197 - Omaha
Join us on April 6th in Omaha for SQL Saturday #197. SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.
The Command Shell
This Friday Steve Jones talks about xp_cmdshell and the security regarding its use. Do you have any holes that might exist if administrators are allowed to use this tool on their instances?
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Alamat BCA KCP Ampera Telp/Wa (+62) 821-8200-233
Call Cs 08218200233 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu,...
Alamat BCA KCP Ambasador Telp/Wa (+62) 821-8200-203
Call CS 08218200203 Mal & Apartemen Ambasador, Jl. Prof. DR. Satrio No.R.18 Lt Dasar,...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers