Collecting Data with Elastic Database Jobs in SQL Azure
In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.
2018-10-11
2,818 reads
Additional Articles
Fifty Different Ways to Enact Data Privacy Laws?
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.
2018-10-11
2,871 reads
Get SQL Server Row Count and Space Used with the sp_rows
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.
2018-10-10
3,405 reads
Databases with MAXSIZE Set
When a database grows to the MAXSIZE the database will not grow anymore and if someone tries to add more rows they will get an error saying the database is full. Greg Larsen shows you how to find all database files that have their max_size set.
2018-10-09
2,540 reads
Power BI Introduction: Publishing Reports to the Power BI Service — Part 8
Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards can be built. Robert Sheldon demonstrates how to publish reports from Power BI Desktop to the Power BI Service. Once published, the visualizations can be filtered, drilled into, or pinned to a dashboard.
2018-10-08
3,198 reads
SQL Server Cursor Example
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them..
2018-10-08
3,419 reads
6 DBA Lessons I Wish Someone Would Have Taught Me Earlier
The name of the Agent job isn't necessarily what it does, and just because your'e not getting failure emails doesn't mean the job is working.
2018-10-05
6,492 reads
Insert missing SQL Server IDENTITY column values using SET IDENTITY_INSERT command
In this tip we look at how to insert missing values for an identity column using the SET IDENTITY_INSERT command.
2018-10-04
2,900 reads
Using Azure Storage Explorer
Azure Storage can store many types of data, from NoSQL tables to VHDs. In this article, Supriya Pande explains how to work with Azure Storage Explorer, a tool that makes it easy to manage storage in Azure. She also provides an example of using the Azure Storage .NET SDK to upload files.
2018-10-04
2,593 reads
Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption
In this tip look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
2018-10-03
2,545 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Alamat Kantor BCA KCU Wisma Asia Telp:08218200174
Via Wa:628218200174 Alamat Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174
Via Wa:628218200174 Alamat. Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Alamat Kantor BCA KCU Wisma Millenia Telp:08218200174
Via Wa:628218200174 Alamat.Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec. Tebet,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers