Create EndPoint
Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett
2016-10-03 (first published: 2016-09-16)
3,158 reads
SQl Hunt
- Interests: Like to make friendship with people.
Read all trace file data and print the action performed
If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.
2016-09-12 (first published: 2014-11-12)
2,348 reads
2016-08-29 (first published: 2015-03-29)
1,786 reads
Query to find the Job Output file location at each job step
Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2016-08-24 (first published: 2015-04-24)
3,342 reads
Check Up Size Of Each Folder In a Path
If you have any requirement to check the size of each sub-folders in a path, you can use my script.
2016-08-18 (first published: 2015-05-20)
1,683 reads
Alter database owner to SA from any user details on all user databases
Alter database owner to SA from any other user details against all user databases
2016-08-17 (first published: 2015-01-13)
1,879 reads
Delete SQL Instance name from default backup location
IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.
2016-08-15 (first published: 2015-03-23)
730 reads
Job Step Log Output file path
If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.
2016-06-30 (first published: 2016-05-20)
1,561 reads
Send Email to recipients with Attachment using PowerShell
If you have a requirement to send email to recipients with attachment, can use the script.
2016-06-24 (first published: 2016-05-17)
3,158 reads
Run a specific query across all servers using powershell
Run a specific query across all servers using powershell
2016-05-31 (first published: 2015-03-06)
3,273 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers