Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Code
  • Presentations
  • Publications
  • Contact

Month: April 2015

sql trace to filter on table

  • Posted onApril 20, 2015
  • sql server administration

You can’t set filter to trace specific table directly. What you can do is specify a filter for Text Data: File -> Properties -> Event Selection -> Column Filters -> TextData -> Like -> [Table Name]

Continue Reading

sql server – server side traces

  • Posted onApril 20, 2015
  • sql server administration

https://msdn.microsoft.com/en-us/library/cc293613.aspx start trace – stop trace, then script out file –> export –> script set InsertFileNameHere and run on server retrieve data from — SELECT * FROM fn_trace_gettable(‘c:inside_sql.trc’, 1) stop trace and don’t continue — EXEC sp_trace_setstatus 2, 2

Continue Reading

Error: Cannot use file for clustered server

  • Posted onApril 14, 2015
  • network administration

http://www.sysads.co.uk/2013/12/error-file-clustered-server/ Expand Services and applications, click on your clustered application (in my case is the default SQL Server (MSSQLSERVER)), right-click the SQL Server resource, and then click Properties Click the Insert button to add an additional row, then select the new shared disk that will…

Continue Reading

replace shared disk on failover cluster

  • Posted onApril 13, 2015
  • network administration

http://blogs.technet.com/b/askcore/archive/2011/08/26/replacing-a-shared-disk-on-a-2008-failover-cluster.aspx

Continue Reading

Newletter Signup

Loading

Recent posts

  • T-SQL Tuesday #186 Invitation – Managing Agent Jobs
  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?

Categories

  • audit (2)
  • azure (45)
  • containerization (14)
  • datawarehousing (4)
  • dba (52)
  • editorial (8)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (7)
  • other (8)
  • performance (1)
  • postgresql (16)
  • powershell (1)
  • security (3)
  • sql server (22)
  • sql server administration (124)
    • jobs (4)
  • sql sever syntax (78)
  • terraform (5)
  • tsql2sday (2)
  • web dev (6)
  • zen (2)

Archives

  • June 2025 (1)
  • May 2025 (2)
  • April 2025 (2)
  • March 2025 (3)
  • February 2025 (3)
  • January 2025 (4)
  • November 2024 (3)
  • October 2024 (1)
  • September 2024 (2)
  • August 2024 (1)
  • July 2024 (5)
  • June 2024 (4)
  • May 2024 (4)
  • April 2024 (3)
  • March 2024 (2)
  • February 2024 (1)
  • January 2024 (5)
  • December 2023 (2)
  • November 2023 (5)
  • October 2023 (1)
  • September 2023 (1)
  • August 2023 (2)
  • July 2023 (2)
  • June 2023 (3)
  • May 2023 (4)
  • April 2023 (3)
  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (4)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • T-SQL Tuesday #186 Invitation – Managing Agent Jobs
  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?
© Copyright 2025 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress