Nominations for the Exceptional DBA of 2011 opened on May 25. Bob Cramblitt spoke with past award winners to find out what has happened to them since receiving the award and to get advice for people thinking about nominating themselves or colleagues.
I work in a fairly large and unwieldy SQL Server shop. Our environment is the wild west. I have DBAs and Developers on my team that create SQL Server Agent Jobs all of the time and there is never an operator setup to email anyone based on a failure condition. I know the right solution here is to "tame the wild west" by locking down the environment and setting up a change management process, but I think that is a topic for another day. Can you give me some idea of how to identify the new recently created SQL Server Agent Jobs and Jobs without an operator setup to email us for a failure condition? I would like to receive emails when either of these conditions occur. Check out the solution to this tip to learn how.
Today we have a guest editorial from Chris O’Connor as Steve is on vacation. Today Chris talks about the responsibilities of application developers in safeguarding the data when there is no DBA.
Integration Service is running on rnage of dynamic port and user can’t connect Integration Service remotely.
Free training from Pragmatic Works, Microsoft and SQLServerCentral. Learn about SSAS performance, SSIS Configurations, GIS in SSRS and more.
SQL Server 2008 R2 Integration Services offer a number of built-in features that simplify ETL, but they come with limited functionality. Here's a solution.
From MVP Jacob Sebastian, creator of the T-SQL Challenges, there is a BI quiz throughout the month of June. Enter and answer questions each day for the chance to win prizes.
Red Gate has released SQL Monitor 2.3, providing improved data analysis and the ability to receive alerts through PagerDuty.
Security is a big concern with data, especially when there is another company involved. Steve Jones notes today that cloud vendors need to beef up their work in this area.
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers