(Jason Brimhall) One of the beauties of using a tool such as Extended Events (XEvents) is the versatility and ease of use. XEvents can be used for so many things to help an aspiring DBA or Developer do their job better.
Tag: sql server
SQL SERVER – Error: 5173 – One or More Files do Not Match the Primary File of the Database
(Pinal Dave) I was recently helping my client to SQL recovery from a hardware failure. I have implemented a good backup strategy for them, and things were easy.
Data Exploration and Aggregation with SQL Server and R – Part 1
(Gauri Mahajan) Data exploration and aggregation are two significant aspects of data analysis while processing with transactional data stored in SQL Server with R for statistical inferences.
SQL SERVER – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File
(Pinal Dave) This blog would be useful for those who are recovering from a disaster and are trying to rebuild system databases for SQL Server.
Removing HTML Tags From Text In Power Query/Power BI
(Chris Webb) Recently I found I needed to remove all the HTML tags from some text in Power Query.
SQL Server Backup and Restore History Queries
(Eric Blinn) I want to learn more about the SQL Server MSDB database and what it can offer me as a DBA.
Containers: More on Volumes
(Grant Fritchey) In my last post I showed how you can create a volume with your container. I then showed a few things you can with a container using a volume. I want to explore volumes just a little bit more.
Should I Fire Someone Who Is Interviewing With Other Companies?
I found out that my employee is constantly going on interviews with other companies. Do I fire him?
Which Query Used the Most CPU? Implementing Extended Events
(Grant Fritchey) A question that comes up on the forums all the time: Which query used the most CPU. You may see variations on, memory, I/O, or just resources in general.
SQL varchar data type deep dive
(Gauri Mahajan) In this article we’ll review the SQL varchar data type including a basic definition and overview, differences from varchar(n), UTF-8 support, Collation, performance considerations and more.