Shrinking the log file script for SQL server database
AdvertisementsShrinking the log file script for SQL server database
This script mainly for a DBA’s, because most of the time...
2011-04-10
2,031 reads
Blog Posts
So, what’s this heap thing?
G’day,
I’ve been asked a few times lately to explain what a heap is.
I’m quite happy to do this, but I...
2011-04-10
2,410 reads
SQLBits 8 – That’s a Wrap
This weekend saw the 8th SQLBits conference take place amidst glorious British sunshine by the sea in Brighton.
For those unable...
2011-04-10
890 reads
Powershell Day 9
Day 9 Process and Service Service: For Powershell we can also work with services. You can see which all services...
2011-04-09
377 reads
A SQL Server Hardware Nugget A Day – Day 8
For Day 8 of my SQL Server hardware series, I want to give my current recommended Intel Processor List for...
2011-04-08
427 reads
An Appeal to Those Writing Training Documentation and Labs
I'm coming to the end of a week of training in a Microsoft Official Curriculum (MOC) Course. I should expect...
2011-04-08
934 reads
Confessions of a DBA - Part 1
Couple of year's back I brought the SQL Server down to its pathetic knees by using a HINT. Yes, with...
2011-04-08
1,503 reads
Find Table Heaps Using Policy-Based Management
This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already...
2011-04-08
1,025 reads
For Your Friday Enrichment: Get Alifeatoll
I have made something for your pleasure and entertainment, and placed it on the MidnightDBA YouTube Channel. Please to enjoy...
2011-04-08
516 reads
Hostettler & the Bottleneckers
A bit of fun !
A long long time ago before the dawn of 2010, somewhere to the South of the...
2011-04-08
619 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
BCA KCU WISMA MILLENIA Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec....
Alamat Kantor BCA KCP Blok M Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta...
BCA KCU KUNINGAN Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers